|  | Formula | | |
| | | Accesscrzy |  |
|  Posted: Tue Sep 02, 2008 7:08 pm Post subject: Formula |  |
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! |
| |
| | | Rick Rothstein | |
| | Posted: Tue Sep 02, 2008 7:27 pm Post subject: Re: Formula | |
Try this...
=SUMPRODUCT((B1:B1000<--"4/03/2008")*(B1:B1000<>"")*(C1:C1000=""))
Rick
--
Rick (MVP - Excel)
"Accesscrzy" <Accesscrzy@discussions.microsoft.com> wrote in message
news:394B74D7-BC93-4630-94F2-3D212DFFA057@microsoft.com...
| Quote: | 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 | |
| | Posted: Tue Sep 02, 2008 9:16 pm Post subject: Re: Formula | |
Try this:
=SUMPRODUCT((C1:C10="")*(B1:B10<--"4/03/2008"))
Adjust the ranges to suit.
Hope this helps.
Pete
On Sep 2, 10:08 pm, Accesscrzy <Accessc...@discussions.microsoft.com>
wrote:
| Quote: | 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! |
|
| |
| | | Accesscrzy | |
| | Posted: Wed Sep 03, 2008 3:05 pm Post subject: Re: Formula | |
Thank you... that was exactly what I needed. Where do ya'll learn this
stuff? Once again, this is an awesome site. Thank you!
"Rick Rothstein" wrote:
| Quote: | Try this...
=SUMPRODUCT((B1:B1000<--"4/03/2008")*(B1:B1000<>"")*(C1:C1000=""))
Rick
--
Rick (MVP - Excel)
"Accesscrzy" <Accesscrzy@discussions.microsoft.com> wrote in message
news:394B74D7-BC93-4630-94F2-3D212DFFA057@microsoft.com...
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!
|
|
| |
|
|
