Sumproduct if

F

frank

I want a worksheet to perform a SUMPRODUCT but only if the
rows fall between certain dates. please help. please
help!

thank you
 
R

Ron de Bruin

=SUMPRODUCT((B1:B10>=DATE(2003,1,12))*((B1:B10<=DATE(2003,7,18)))*C1:C10)

This will sum the cells in C if the date is between the two dates in the formula
 

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

reporting list of dates 1
Conditional sum in a named range 8
SUMIF 7
Sumproduct Repeatability 3
Using If with SumProduct help please! 2
Show if between two dates 4
sumproduct, lookup? 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1

Top