SUMIF
 

Help..help..help...

How can I use sumif if the value in the cells are not exactly the same?
Is it possible to do that?

Item A $100
Item B $150
Item A1 $175
Item B1 $165
Item A4 $200

How can I total all item A (including A1, A4) using sumif?
Or should I use other formula for this condition?


Thanks

SUMIF
 

One way:

=SUMPRODUCT((LEFT(A2:A50,6)="Item A")*B2:B50)

Hope this helps
Rowan

"broogle" wrote:

Help..help..help...

How can I use sumif if the value in the cells are not exactly the same?
Is it possible to do that?

Item A $100
Item B $150
Item A1 $175
Item B1 $165
Item A4 $200

How can I total all item A (including A1, A4) using sumif?
Or should I use other formula for this condition?


Thanks

SUMIF
 

Thanks Rowan!

Again, it works!!!

SUMIF
 

You're welcome!

"broogle" wrote:

Thanks Rowan!

Again, it works!!!