Tough One: SUMIF or Conditional Sum

[bzwerlin]

I've been struggling with this one all day and just can't seem to figure it out. Any help would be greatly appreciated!

I'm building a table like this:

Month Group 1 Group 2
Dec $$ $$
Jan $$ $$
Feb $$ $$

Where the $$ value is the sum for the group in the given month. The entire data set is held on a separate sheet. Basically, I need to limit the sum to (1) the month; and (2) the Group ID.

The trick is that I'd like to have a flexible formula which I could just copy-down to the next month--but I'm not sure how to use (if it's possible) cell references within a SumIF or Conditional Sum formula. In fact, any time I edit the conditional sum formula it eliminates the braces. So if the Date is in A2 and the Group in B1 I would insert those references into the formula and just copy-paste down.

Any ideas on if this is possible? To me it seems it would be difficult to do this in SumIF function as you cannot limit by two factors, but in the conditional sum function I can't seem to edit the formula without it just becoming a big text string (as mentioned it eliminates the braces for some reason)

Thanks for your help.

 

[SkipVought]

Hi,

This sounds like a job for....

The PivotTable Wizard!

Your source data is in another sheet?

Well on THAT sheet, you activate the PivotTable Wizard

In Layout drag the

Dates to the ROW AREA and

Groups to the COLUMN AERA and

Amount to the DATA AREA and select Sum of Amount

THe Table Options can total the rows and columns.

and

VOLA!

I think that's what you might need!



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com