SumIf Question
Hi,
There's nothing wrong with your formula so if it's not returning an answer
then suspect the data. First try this but note it will pick up Bob anywhere
in the cell
=SUMIF(A3:A50,"*Bob*",G3:G50)
If that doesn't work, try this. Put a 1 in an empty cell and copy it. Select
G3 - G50 and
Edit|Paste special - select 'Multiply' and click OK
Mike
"Tasha" wrote in message
...
I have a list of names in cell a3:a25 and what to add the sum from column
g.
please help
sumif (a3:a50,"Bob", g3:g50)
--
Tasha
|