Thread: SumIf Question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H[_6_] Mike H[_6_] is offline
external usenet poster
 
Posts: 11
Default 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