SUMIF, multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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: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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif formula 4
SUMIF - how to enter a second criteria 1
Dynamic Sum-if function 5
Sum if with multiple ranges 2
SUMIF Function 1
Filtering with SUMIFS 1
using sumifs with multiple criteria? 3
Sumif with two criteria including a date range 4

Back
Top