SUMIF but where Criteria is a Date Range

Hi

I am trying to get a SUMIF formula to work where the following: -
RANGE = Column N:N (These are all a list of dates)
CRITERIA = Cell C20:D20 (These are the dates i want to look at)
SUM_RANGE = Column P:P

Basically, I want to SUM all the numbers on Column P where the date in Column N falls between and including the dates in Cell C20 and D20

Any help you could provide would be great.

thanks


Hi

In attachement, I want to show in the YELLOW cells the SUM of Column P where the Date in Column N is between the Dates in column C and D.

thanks

Hi,
Does this formula do what you want?

Please Login or Register  to view this content.

You need to enter this formula with Control+Shift+Enter (when you want to see result of formula hit Control+Shift+Enter instead of hitting Enter)

Best regards,
gb1331