SUMIF, multiple criteria

L

Lauren753

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!
 
D

Domenic

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

=SUM(INDEX(B1:B100,LARGE(IF(B1:B100<>"",ROW(B1:B100)-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!
 
Top