Simple Sumif formual with Criteria
On Feb 20, 9:22*pm, Geo wrote:
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
You and use either of these formulas:
=SUMPRODUCT(--(A1:A9="Muziq")*(B1:B9="")*1)
or
=SUM(IF((A1:A9="Muziq")*(B1:B9=""),(A1:A9="Muziq") *(B1:B9="")*1))
entered as an array formula with Ctrl+Shift+Enter
They both give the same result.
|