Formula

[Accesscrzy]

I need a formula for this:
If C1 is blank and B1 is less than 4/03/2008 count as 1.
Answer: 2

A B C
1 Almond Joy 04/01/2008

2 Baby Ruth 04/02/2008

3 MARS 03/28/2008 04/01/2008

4 Mounds 04/10/2008 04/15/2008

5 Reeses 05/01/2008

6 Starburst 03/25/2008 03/31/2008

Thank you!

 

[Pete_UK]

Try this:

=SUMPRODUCT((C1:C10="")*(B1:B10<--"4/03/2008"))

Adjust the ranges to suit.

Hope this helps.

Pete

 

[Rick Rothstein]

Try this...

=SUMPRODUCT((B1:B1000<--"4/03/2008")*(B1:B1000<>"")*(C1:C1000=""))

Rick

 

[Accesscrzy]

Thank you... that was exactly what I needed. Where do ya'll learn this
stuff? Once again, this is an awesome site. Thank you!