Code: 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

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
>
>

Thanks Rowan!

Again, it works!!!

You're welcome!

"broogle" wrote:

> Thanks Rowan!
>
> Again, it works!!!
>
>