software

Hello, I am fairly new to advanced excel functions. I have a question that
may require multiple steps. I will describe my issue as simply as I can.

In cell E1, I need to SUM the values in column D if columns A, B, amp; C all
meet specific criteria.

For Example: IF A3=2006, B3=3, amp; C3=1, THEN D3 should be added to E1.
If any one of the three criteria is not true then D3 should not get added to
E1.

Thanks to everyone who contributes to this site. It has been very helpful.
-Mike[E1] =SUMPRODUCT(--(A2:A100=2006),--(B2:B100=3),--(C2:C100=1),D2100)

Regards,
KL
quot;mike camburnquot; lt;mike gt; wrote in message ...
gt; Hello, I am fairly new to advanced excel functions. I have a question that
gt; may require multiple steps. I will describe my issue as simply as I can.
gt;
gt; In cell E1, I need to SUM the values in column D if columns A, B, amp; C all
gt; meet specific criteria.
gt;
gt; For Example: IF A3=2006, B3=3, amp; C3=1, THEN D3 should be added to E1.
gt; If any one of the three criteria is not true then D3 should not get added to
gt; E1.
gt;
gt; Thanks to everyone who contributes to this site. It has been very helpful.
gt; -Mike
gt;

To simplify your criteria choices, how about entering them at the top of
their respective columns instead of quot;hard-codingquot; them in the formula.
This makes changing them easier then having to revise the formula itself,
plus it helps with equalizing the data formats, since I'll assume that
quot;2006quot; is a date.

Try something like this:

=SUMPRODUCT((TEXT(A3:A100,quot;yyyyquot;)=TEXT(A1,quot;yyyyquot;)) *(B3:B100=B1)*(C3:C100=C1)*D3100)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;mike camburnquot; lt;mike gt; wrote in message
...
gt; Hello, I am fairly new to advanced excel functions. I have a question that
gt; may require multiple steps. I will describe my issue as simply as I can.
gt;
gt; In cell E1, I need to SUM the values in column D if columns A, B, amp; C all
gt; meet specific criteria.
gt;
gt; For Example: IF A3=2006, B3=3, amp; C3=1, THEN D3 should be added to E1.
gt; If any one of the three criteria is not true then D3 should not get added
gt; to
gt; E1.
gt;
gt; Thanks to everyone who contributes to this site. It has been very helpful.
gt; -Mike
gt;