software

Hello there,

Based on the attached table, I'm trying to show a total for:

if column b is quot;outside servicesquot; AND column c is quot;1quot;, then take the
total from column a.
(In other words, I'd like the function to know to add cells a2, a3 and
a5 to produce 212459).

I'm getting my quot;ifquot; statements messed up somewhere and am wondering if
anyone could help me?

Thank you very much,
Gina -------------------------------------------------------------------
|Filename: questions.doc |
|Download: www.excelforum.com/attachment.php?postid=4163 |
-------------------------------------------------------------------

--
gina_b
------------------------------------------------------------------------
gina_b's Profile: www.excelforum.com/member.php...oamp;userid=29996
View this thread: www.excelforum.com/showthread...hreadid=496867Hi!

Try something like this:

=SUMPRODUCT(--(B1:B10=quot;outside servicesquot;),--(C1:C10=1),A1:A10)

Better to use cells to hold the criteria:

D1 = outside services
E1 = 1

=SUMPRODUCT(--(B1:B10=D1),--(C1:C10=E1),A1:A10)

Adjust the ranges to suit. (just can't use entire columns like A:A)

Biff

quot;gina_bquot; gt; wrote in
message ...
gt;
gt; Hello there,
gt;
gt; Based on the attached table, I'm trying to show a total for:
gt;
gt; if column b is quot;outside servicesquot; AND column c is quot;1quot;, then take the
gt; total from column a.
gt; (In other words, I'd like the function to know to add cells a2, a3 and
gt; a5 to produce 212459).
gt;
gt; I'm getting my quot;ifquot; statements messed up somewhere and am wondering if
gt; anyone could help me?
gt;
gt; Thank you very much,
gt; Gina
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: questions.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4163 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; gina_b
gt; ------------------------------------------------------------------------
gt; gina_b's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29996
gt; View this thread: www.excelforum.com/showthread...hreadid=496867
gt;

Biff,
Thanks so much.
I'll give it a try and see what happens.
I REALLY appreciate it!
Thanks and Happy New Year,
Gina--
gina_b
------------------------------------------------------------------------
gina_b's Profile: www.excelforum.com/member.php...oamp;userid=29996
View this thread: www.excelforum.com/showthread...hreadid=496867