Excel 2007 : Multi Conditional Sum

Hi

Try to explain...could do with some help please

I have 2 sum if statements if you like that i need to bring togeather and them calulate a summary of a certain colounm if it matches the criteria.

I have it like this

Col A Col B Col C
Brand Month Revenue

What i need it to do is IF IT = a certain brand AND a certain month then add togeather the revenue from COL C.

Im using this at the moment that adds togeather the revenue from picking up the 'brand'
=SUMIF('Input data'!$A$7:$D$321,"Climate",'Input data'!$AC$7:$AC$321)

But as i said above i need it to pick up the brand, then the month, then add togeather the Revenue any help would be GREAT!!!!!!!!!! thanks very much

Pre XL2007 there are a few single cell multi conditional summation/count options - SUMPRODUCT is perhaps the most common:

Please Login or Register  to view this content.

In truth the above is something of a guess given we don't know what "Month" stores be it Text strings or actual Date Values - in the above we assume Text String

If in doubt post a small sample that accurately reflects your real file - data types etc...

Sheet1

Col 1 (brand) Col 2 (Month) Col 3 (Total Revenue)

Plumb Aug £295
Pipe Sept £180

Sheet 2

(Col1) Col 2(brand - Pipe) Col 3 (pipe)
Aug £295
Sept £180

So basically i need a forumula in sheet 2 that goes look at sheet 1, if its Plumb & Aug then total the revenue up (sum)

My forumula above that i have at the moment is just going if its Plumb then total the revenue up, but as the months go on theres alot of lines and it will be a ball ach to sort out hope this helps, couldent copy and paste the sheet in doesnt come out right?

Post a sample file - it will account for half a dozen posts - a lot of factors remain unclear at this stage.

If sheet2 need only list brands that appear in Sheet1 I would suggest you investigate Pivot Tables.

If you're generating a matrix then I would avoid using SUMPRODUCT to populate it - it's not efficient.

Hi how can i post a sample file? Thanks. Jez

use the paperclip icon in the Reply Window - if you can not see it first click GoAdvanced and proceed from there.

No need to quote prior posts in their entirety - it just clutters your thread and the board in general. Thanks.