Count multiple conditions

**[email protected]** · 07-09-2012, 08:27 AM

Excel 2003
I have a database in which A=Monday to Friday ,C=P and Rs, E=window number 1-4 ,and F=Customers name eg "A.Smith. I need a formula that will count have many cutomers in mon/p/1,mon/p/2 ect but in F the may be some blanks so the formula must not count them, can you help.
Steve

**Vinodsralian** · 07-09-2012, 08:31 AM

can you upload a sample file, with the desired output?

**NBVC** · 07-09-2012, 08:33 AM

something like:

=SUMPRODUCT(($A$2:$A$100="Mon")*($C$2:$C$100="P")*($E$2:$E$100=1)*($F$2:$F$100<>""))

you can replace criteria with cell references containing those criteria... and then copy down

You can use a Pivot table also...

**[email protected]** · 07-09-2012, 09:27 AM

nbvc
your formula is great but returns the wrong value it says 20 when there are 39 names in m/p/1 any ideas and sorry dont know what a pivot table is

**NBVC** · 07-09-2012, 09:48 AM

Make sure that some of those entries don't have extra spaces in them. Also make sure your ranges cover the whole database.

Here is some info on Pivot Tables... they are quick and easy way to organize and summarize data:

http://peltiertech.com/Excel/Pivots/