Countifs working with SUM/SUMIF

[DPChristman]

So, here is my conundrum...

I am trying to summarize data by month, based on a couple of variables.

Example:

If the Value in a column is YES, and a value in another column is a specific month, then summarize the total dollars in a third column.

Now, if I was only looking for the count of items, I could do this easily with a countifs function.

However, I am looking the dollars in a third column.

I know I can do this sloppily, by creating a (hidden) column that would say something like =F5&BN5 to achieve a result of FEBYES in column BP, then do a =sumif BP:BP=FEBYES,AM:AM, but this seems ridiculously complicated, and by time I am done, I will have a bunch of extra columns added to spreadsheet.

There has to be a simpler way to accomplish this.

Any Thoughts?

Thanks,

Dan

BTW we are talking office 2010

 

[etaf]

Now, if I was only looking for the count of items, I could do this easily with a countifs function.

try using a SUMIFS()
should work with 2010

 

[DPChristman]

Thanks. That worked.
I've actually used that before, but not alot.

My problem is, I keep getting the order wrong, selecting the criteria range first.

Got it now, till the next time I forget : )

 

[etaf]

they changed it from sumif() and sumifs()
so sumif() has the sumrange optional , if not the same as the criteria at the end
and
sumifs()
at the beginning

so i always have to check in the formula bar too