Sumifs

Hi I have uploaded the sheet as an example

What I basically need is a formula that sums in sheet 2 cell d4, from sheet 1, if, in col A it reads "Total Revenue" and in col F it reads "Not Assigned" then populate the respective months.

Sheet 1 in reality has hundreds of lines so need to be able to copy down.

Thanks

Put this in D4 of Sheet2:

=SUMIFS(Sheet1!I:I,Sheet1!$F:$F,$C4,Sheet1!$A:$A,"Total Revenue")

then copy across to O4

Hope this helps.

Pete

Thanks for the heads-up, Trevor. With the thread title and the filename both being called sumifs, I didn't check.

An alternative would be to put this in D4 of Sheet2:

=SUMPRODUCT(Sheet1!I$2:I$1000,(Sheet1!$F$2:$F$1000=$C4)*(Sheet1!$A$2:$A$1000="Total Revenue"))

which can then be copied across and which will handle up to 1000 rows on Sheet1.

Hope this helps.

Pete