SumIf Question
 

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

SumIf Question
 

That looks right, that will add all values in G where the value in A is Bob.

Was there more to it?

--
__________________________________
HTH

Bob

"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

SumIf Question
 

Tasha;277589 Wrote:
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)
--
TashaYou need to use SUMPRODUCT take a look here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a great detailed
explanation with worked examples!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77552

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

SumIf Question
 

How can I alter this to work for 5 different names
--
Tasha


"Bob Phillips" wrote:

That looks right, that will add all values in G where the value in A is Bob.

Was there more to it?

--
__________________________________
HTH

Bob

"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

SumIf Question
 

If you want one formula to sum for 5 different names...
here are a couple approaches:
=SUM(SUMIF(A5:A50,{"alpha","bravo","charlie","delt a","echo"},G5:G50))
or
=SUMPRODUCT((A5:A50={"alpha","bravo","charlie","de lta","echo"})*G5:G50)

Also, you could reference a list, instead of putting the values in the
formula
Example:
I1:I5 contains this list:
Alpha
Bravo
Charlie
Delta
Echo

and the formula would now be a combination of the two above methods:
=SUMPRODUCT(SUMIF(A5:A50,I1:I5,G5:G50))

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)
"Tasha" wrote in message
...
How can I alter this to work for 5 different names
--
Tasha


"Bob Phillips" wrote:

That looks right, that will add all values in G where the value in A is
Bob.

Was there more to it?

--
__________________________________
HTH

Bob

"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