software

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,quot;Joe Smithquot;,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: www.excelforum.com/member.php...oamp;userid=33473
View this thread: www.excelforum.com/showthread...hreadid=532772
Try SUMPRODUCT()

=SUMPRODUCT(--(A1:A50=quot;Joe Smithquot;),--(B1:B50=quot;Equot;),(C1:C50))--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: 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: www.excelforum.com/member.php...oamp;userid=33473
View this thread: www.excelforum.com/showthread...hreadid=532772
Same formula but remove the last condition

so it would be:

=SUMPRODUCT(--(A1:A50=quot;Joe Smithquot;),--(B1:B50=quot;Equot;))--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: 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: www.excelforum.com/member.php...oamp;userid=33473
View this thread: www.excelforum.com/showthread...hreadid=532772
You're very welcome. You have a lovely smile(s).--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=532772
You are a kind person.... but I hate to bother you again, but what if I
want to find out how many times the entire Smith family (A) has used
code E (B)?

I tried using quot;Smith*quot; and I get nothing... does this mean that
wildcards don't work with this formula or am I overlooking something?--
DiDi
------------------------------------------------------------------------
DiDi's Profile: www.excelforum.com/member.php...oamp;userid=33473
View this thread: www.excelforum.com/showthread...hreadid=532772One way

=SUMPRODUCT(--(LEFT(A2:A20,5)=quot;Smithquot;),--(B2:B20=quot;Equot;))--

Regards,

Peo Sjoblom

nwexcelsolutions.com

quot;DiDiquot; gt; wrote in message
news
gt;
gt; You are a kind person.... but I hate to bother you again, but what if I
gt; want to find out how many times the entire Smith family (A) has used
gt; code E (B)?
gt;
gt; I tried using quot;Smith*quot; and I get nothing... does this mean that
gt; wildcards don't work with this formula or am I overlooking something?
gt;
gt;
gt; --
gt; DiDi
gt; ------------------------------------------------------------------------
gt; DiDi's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33473
gt; View this thread: www.excelforum.com/showthread...hreadid=532772
gt;

Worked like a charm .... thanks to all who helped. I am in your debt.--
DiDi
------------------------------------------------------------------------
DiDi's Profile: www.excelforum.com/member.php...oamp;userid=33473
View this thread: www.excelforum.com/showthread...hreadid=532772
Spreadsheet is almost done, everything looks great but - here's the
formula so far....

=SUMPRODUCT(--('Closed IT Jobs'!$D$2:$D$75=$B15),--('Closed IT
Jobs'!$E$2:$E$75=quot;Iquot;),('Closed IT Jobs'!$F$2:$F$75))/E15

How do I get rid of the quot;DIV/0!quot; error when cell E15 contains a zero. I
would like the answer to be 0. I tried an =IF and maybe I'm not setting
it up right, but I'm getting an error.

Any and all help will be appreciated.--
DiDi
------------------------------------------------------------------------
DiDi's Profile: www.excelforum.com/member.php...oamp;userid=33473
View this thread: www.excelforum.com/showthread...hreadid=532772