Excel 2007 : SUM inside SUMIFS?

**thart21** · 09-30-2011, 01:30 PM

Good morning,

I have the following formula which works great:

=SUMIFS('Late Details'!$AR:$AR,'Late Details'!$C:$C,$A$3,'Late Details'!$J:$J,$A$1,'Late Details'!$N:$N,$A54,'Late Details'!$AO:$AO,">0")

The last criteria however that reads "Where Late Details, column AO is >0 needs to read
"where the sum of column AO through AQ is >0.

Tried to adjust formula to 'Late Details'!$AO:$AQ,">0") with no luck. I think I'm getting close with this one, no errors in this, but it is not giving me results.

=IF(SUM($AO:$AU),">0")*SUMIFS('Late Details'!$AR:$AR,'Late Details'!$C:$C,$A$3,'Late Details'!$J:$J,$A$1,'Late Details'!$N:$N,$A60)

Any ideas on what it is missing would be appreciated!

Thanks,

Toni

**daddylonglegs** · 09-30-2011, 01:34 PM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

**Bob Phillips** · 09-30-2011, 01:35 PM

Try using

=SUMPRODUCT(('Late Details'!$C:$C=$A$3)*('Late Details'!$J:$J,$A$1='Late Details'!$N:$N)*($A54,'Late Details'!$AO:$AQ>0)*('Late Details'!$AR:$AR))