CODEWITHSUNDEEP
excelexcel-formula
Ross Symonds
Ross Symonds

Reputation: 87

SUMIFS and ISFORMULA

This formula works

=SUMIF(KO1363:KR1363,">7")

But When I change SUMIF to SUMIFS and add in the ISFORMULA function I do not get the desired results.

=SUMIFS(KO1363:KR1363,KO1363:KR1363,">7",KO1363:KR1363,ISFORMULA(KO1363:KR1363)=TRUE)

I only want the SUMIFS to calculate cells which have formulas in them and a total over 7.

Upvotes: 0

Views: 93

Answers (1)

BigBen
BigBen

Reputation: 50162

Using SUMPRODUCT:

=SUMPRODUCT(KO1363:KR1363*(KO1363:KR1363>7)*ISFORMULA(KO1363:KR1363))

enter image description here

Upvotes: 2

Related Questions