YTD Values based on a Date.

[James8761]

Hi,
I am trying to create a SUMIF based on a date. The Date is based in Sheet 1, Cell C7 and the 12 options that can be input are May 18 through to Apr 19.

In Sheet2, Cells B4:M4 I have the 12 months of the year (May 18 - Apr 19) for Budget data. Then in Cells A7 all the way down to A100 i have a number of headings. The figures appear in Columns B:M as per the dates.

Concentrating on Sheet 2, Row 7. I want to put a formula in Cell O7 that will pick up the YTD Figures based on the Date input in to Cell Sheet 1, Cell C7.

I tried SUMIFS(B7:M7,B4:M4,">=Shetet1!C7"), but this does not work.



Any help appreciated

Kind regards,
James

 

[Joe4]

Try:

[COLOR=#333333]=SUMIFS(B7:M7,B4:M4,">=" & Sheet1!C7)[/COLOR]

 

[James8761]

Try:

[COLOR=#333333]=SUMIFS(B7:M7,B4:M4,">=" & Sheet1!C7)[/COLOR]

Hi,

thanks for the quick response. That works perfect. I just changed the > to < from what you mentioned, but that was my fault for not explaining correctly.

Thanks again,
James

 

[Joe4]

You are welcome.

I just changed the > to < from what you mentioned, but that was my fault for not explaining correctly.

Yes, I thought you might have had the arrow going the wrong way, but wasn't entirely sure from the explanation.