SUMIFS

[ExcelRoy]

Hi all,

i have the following formula

=SUMIFS(Database!$G$1058:$G$16057,Database!$H$1058:$H$16057,C11,Database!$I$1058:$I$16057,J12)

I would like to add another condition to the formula to SUM only if V1 is found in Database!$F$1058:$F$16057

many thanks

 

[Fluff]

You can just add the new criteria to your existing formula.

 

[ExcelRoy]

Yes didn't realize it was so simple, although i had the wrong column referenced!

Thanks

 

[Fluff]

You're welcome & thanks for the feedback.