Simple Sumif formual with Criteria
Try this:
E2:E4 = Muziq, Moto Q, Fusic
Enter this formula in F2 and copy down to F4:
=SUMPRODUCT(--(A$2:A$10=E2),--(B$2:B$10=""))
--
Biff
Microsoft Excel MVP
"Geo" wrote in message
...
Hello,
I'm a Novice at excel
I need a formula that can give me a total for a specific item when the
criteria is blank . There are multiple sheets and I would need it to
update
automically as I add more sheets and Xs to the corresponding item. please
see
ex. below
Column A Column B
Waiting For Model: Phone Ready
Muziq X
Fusic
Muziq
Fusic X
muziq
Moto Q
Fusic
Moto Q
Fusic
...... .....
So what I'm looking for is
Waiting For Model: Total
Muziq 2
Moto Q 2
Fusic 3
Thanks in advance
|