Imbedding in sumif

[OJ]

Hi,
Have you tried wildcards?

=SUMIF(A3:A5,"=POS*",B3:B5)

Hth,
OJ

 

[don]

In =sumif(xxx,yy,zzz) I would like to imbed a statement.

when looking at the criteria I would like to look at selected
positions in the cell instead of the whole cell.

For instance if the rows of the criteria has among other items data
such as
POS charges for VONs
POS charges for RALPHs
ADP expenses
Late fees
etc

Since these rows are not the same I cannot sum them the POS rows as
one item. If I could imbed =left(a1:a500,3) , ie only looking at the
first 3 positions for the criteria range I could find the sum.

However, when I try to do something like:
=sumif(=left(b1:b500,3), a3, c1:c500)
I get an error.

Thanks for any help

Don

 

[Don Guillett]

try
=SUMPRODUCT((B2:B52=A3)*C2:C52)