SUMIF, multiple criteria
 

I think that this is a SUMIF question: I have a spreadsheet with dates going
out to 2025, as production numbers come in, I want to sum the 12 most
current, so i can do a sumif formula with date range, large(range, 15),
production range being the criteria, but I need the formula to also take
into account when there is no date inputed and to only calculate the 12
latest inputted values. Thanx in advance!

Assuming that Column B contains your production numbers, try...

=SUM(INDEX(B1:B100,LARGE(IF(B1:B100<"",ROW(B1:B10 0)-ROW(B1)+1),12)):INDE
X(B1:B100,MATCH(9.99999999999999E+307,B1:B100)))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
Lauren753 wrote:

I think that this is a SUMIF question: I have a spreadsheet with dates going
out to 2025, as production numbers come in, I want to sum the 12 most
current, so i can do a sumif formula with date range, large(range, 15),
production range being the criteria, but I need the formula to also take
into account when there is no date inputed and to only calculate the 12
latest inputted values. Thanx in advance!