YTD Sum Formula.

Nic Sanchez

I am attempting to add up $ in one column based on the date in another column. Been struggling for a few weeks now. Any help I can get would be great.

Paul Newcome

It may have just been a little bit of latent data hanging on the back-end that just took a little longer than it should have to clear out. That happens to me sometimes too.

Paul Newcome

What is your date criteria?

Nic Sanchez

I am glad to see you responded. I have been seeing your post with great success. My date criteria is YTD; Basically 1/1/24 to current

Currently using; =SUMIF({Master - Close Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Master - Booked})

Paul Newcome

Make sure your ranges are set up properly by clicking on the column header for each column as appropriate for each range.

Nic Sanchez

I closed the sheet and just came back to it, and now the formula works. That is a bug, no?

Paul Newcome

It may have just been a little bit of latent data hanging on the back-end that just took a little longer than it should have to clear out. That happens to me sometimes too.