Sum column if 2 other columns meet text and date criteria

**alanelizabeth** · 12-29-2012, 10:49 PM

This may be very basic, and I am not sure if I can describe it well, but what I am trying to do is sum a column of dollar values if the corresponding cells meet date criteria and category criteria. So
A B C
1/15/2012 $15.90 Parking
3/24/2012 $14.25 Equipment

I am trying to populate monthly expense table on a different tab,and have it classified by category, month and year.

Jan 2012
Euipment
Parking
etc.

So if Col A is in Jan 2012, column C is "Parking then sum column B,

I'm sure there are multiple ways to do this, but please don't tell me to use a macro.

Thanks.

**jeffreybrown** · 12-29-2012, 11:03 PM

How's this sample...

**alanelizabeth** · 12-30-2012, 01:09 AM

Thank you!!

Can you tell me what the -- does?

**Winon** · 12-30-2012, 03:08 AM

Hello alanelizabeth,

Welcome to the Forum.

Can you tell me what the -- does?

True or False don't have a stored value in Excel ie: 1 or 0

The "--" coerces the Boolean returns of TRUE and FALSE to 1 and 0

Since you have asked your data to be summarised on a different tab, I have altered the WorkBook, jeffreybrown sent you. (Hope he doesn't mind.)

Also see the "Please consider" note at the bottom of this post.

**jeffreybrown** · 12-30-2012, 10:13 AM

Originally Posted by Winon

Hope he doesn't mind.

No worries...the more the merrier.

To add to Winon's comments, the "--" comes down to a preference issue as there are other methods which do the same thing.

I mostly learned with using "--" so I stick with it, but this resource will give you other options. Sumproduct

Note: Keep in mind, SUMPRODUCT is a very powerful function, however, with 2007+ there are more efficient functions.

SUMIFS and COUNTIFS to name a couple. In the case of your query, SUMPRODUCT was the best choice.