1. I would like to sum the values in column D where the values/text in columns A, B, and C are "A". ""John", and the text in column A is either 2/1/2008 or 5/1/2008.
Any ideas?
Jeff

2. I don't understand the requirement

"... where the values/text in columns A, B, and C are "A". ""John", and the text in column A is either 2/1/2008 or 5/1/2008"

3. Something like
=SUMPRODUCT((D126),--(A1:A26="A"),--(B1:B26="John"),--(C1:C26=DATEVALUE("02/01/2008")))+SUMPRODUCT((D126),--(A1:A26="A"),--(B1:B26="John"),--(C1:C26=DATEVALUE("05/01/2008")))
You'll need to watch the Date formats. I'm sure there is a neater OR solution though.

4. [quote name='mdmackillop' post='767911' date='27-Mar-2009 21:32']Something like
=SUMPRODUCT((D126),--(A1:A26="A"),--(B1:B26="John"),--(C1:C26=DATEVALUE("02/01/2008")))+SUMPRODUCT((D126),--(A1:A26="A"),--(B1:B26="John"),--(C1:C26=DATEVALUE("05/01/2008")))
You'll need to watch the Date formats. I'm sure there is a neater OR solution though.[/quote]

Thanks Mack

5. This is not the answer but it is close. Assume the data is in rows 2:10, the formula below works but it will only check for one date - there may be a way to make it check two dates but I don't know how.

=SUMIFS(D210,A2:A10,"=A",B2:B10,"=JOHN",C2:C10,"=2/1/2008")

[quote name='jlkirk' post='767899' date='27-Mar-2009 17:47']I would like to sum the values in column D where the values/text in columns A, B, and C are "A". ""John", and the text in column A is either 2/1/2008 or 5/1/2008.
Any ideas?
Jeff[/quote]

6. Keep in mind that SUMIFS will work in Excel 2007 (or later) only.

7. To do an OR, Just add the 2 sumifs:

=SUMIFS(D210,A2:A10,"=A",B2:B10,"=JOHN",C2:C10,"=2/1/2008") +SUMIFS(D210,A2:A10,"=A",B2:B10,"=JOHN",C2:C10,"=5/1/2008")

Steve

8. Cool,

I was thinking it might even be easier to use autofilter and sum col D after filtering.

[quote name='sdckapr' post='768079' date='29-Mar-2009 04:07']To do an OR, Just add the 2 sumifs:

=SUMIFS(D210,A2:A10,"=A",B2:B10,"=JOHN",C2:C10,"=2/1/2008") +SUMIFS(D210,A2:A10,"=A",B2:B10,"=JOHN",C2:C10,"=5/1/2008")

Steve[/quote]

9. That would be fine if you wanted the number to be more live. Then SUBTOTAL would be used and it would calculate based on filtered rows. I presume the OP wanted something not just based on the filter, perhaps to make a table of various combinations (though in this case a pivot table might be the most efficient option...)

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•