I know this can be done ... but I'm not exactly sure how. Let's say we
have 3 columns.

Column A contains names which are not unique.
Column B contains a code to indicate, in this case a source for the
data.
Column C has the data that needs to be summed...

I have used =sumif(A1:A50,"Joe Smith",C1:C50) - but how do I get it to
add only Joe Smith's cells in column C when the letter E is in column
B?

It's driving me crazy...


--
DiDi
------------------------------------------------------------------------
DiDi's Profile: http://www.excelforum.com/member.php...o&userid=33473
View this thread: http://www.excelforum.com/showthread...hreadid=532772

Try SUMPRODUCT()

=SUMPRODUCT(--(A1:A50="Joe Smith"),--(B1:B50="E"),(C1:C50))


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=532772

This worked.... You can't imagine how crazy I've been going over this.
It brings up another question regarding multiple conditions.

How can I count up the total number of times that Joe Smith (A) is
using the E code (B)?:)


--
DiDi
------------------------------------------------------------------------
DiDi's Profile: http://www.excelforum.com/member.php...o&userid=33473
View this thread: http://www.excelforum.com/showthread...hreadid=532772

Same formula but remove the last condition

so it would be:

=SUMPRODUCT(--(A1:A50="Joe Smith"),--(B1:B50="E"))


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=532772

That does it .... and to think I wasted a bunch of time trying all sorts
of different fixes.... very, very much appreciated.
:) :) :) (I'm not a big fan of smilies.....but)


--
DiDi
------------------------------------------------------------------------
DiDi's Profile: http://www.excelforum.com/member.php...o&userid=33473
View this thread: http://www.excelforum.com/showthread...hreadid=532772

You're very welcome. You have a lovely smile(s).


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=532772