Formula

A

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!
 
P

Pete_UK

Try this:

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

Adjust the ranges to suit.

Hope this helps.

Pete
 
R

Rick Rothstein

Try this...

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

Rick
 
A

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!
 

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


Top