Please simplify this for me, it works fine but sure is ugly
It's a sum of 7 SUMIF's.
=SUM(SUMIF(D:D,D5,C:C)
+SUMIF(D:D,D6,C:C)
+SUMIF(D:D,D7,C:C)
+SUMIF(D:D,D8,C:C)
+SUMIF(D:D,D9,C:C)
+SUMIF(D:D,D10,C:C)
+SUMIF(D:D,D11,C:C))
I tried (D:D,D5:D11,C:C), that didn't work and I don't know enough about this to try anything else. Just curious mostly.
using XP and excel2007

=SUM(SUMIF(D:D,D5,C:C)
+SUMIF(D:D,D6,C:C)
+SUMIF(D:D,D7,C:C)
+SUMIF(D:D,D8,C:C)
+SUMIF(D:D,D9,C:C)
+SUMIF(D:D,D10,C:C)
+SUMIF(D:D,D11,C:C))
I tried (D:D,D5:D11,C:C), that didn't work and I don't know enough about this to try anything else. Just curious mostly.
using XP and excel2007
Last edited: