COUNTIF for date and amount

  • Thread starter Thread starter Outlook, eh?
  • Start date Start date
O

Outlook, eh?

I am looking for a function to find money values within certain ranges and
within certain date ranges:

Here is what the data I will get will look like

A B
$15 1/12/10
$20 7/5/07


I understand how to count gifts by the dollar amount range using countif,
but I don't know how to create or add the date range.

Thanks a lot for your help,
-B
 
Try this...

Use cells to hold the criteria.

Amount boundaries:

D1 = lower boundary = 10
E1 = upper boundary = 50

Date boundaries:

D2 = lower boundary = 1/1/2010
E2 = upper boundary = 1/15/2010

Then:

=SUMPRODUCT(--(A1:A10>=D1),--(A1:A10<=E1),--(B1:B10>=D2),--(B1:B10<=E2))

If you're using Excel 2007 you can use this:

=COUNTIFS(A1:A10,">="&D1,A1:A10,"<="&E1,B1:B10,">="&D2,B1:B10,"<="&E2)
 
Back
Top