someone please shorten this formula...
How about:
=sumif(darin!d3:d6,"A",darin!c3:c6)+sumif(jasmine! d3:d6,"A",jasmine!c3:c6)
Regards,
Fred
"wildwheelz" wrote in message
...
It's hard to describe what I am doing, but here's my formula...
=IF(COUNTIF(DARIN!D3,"=A"),SUM(DARIN!C3),0)+IF(COU NTIF(JASMINE!D3,"=A"),SUM(JASMINE!C3),0)
+IF(COUNTIF(DARIN!D4,"=A"),SUM(DARIN!C4),0)+IF(COU NTIF(JASMINE!D4,"=A"),SUM(JASMINE!C4),0)
+IF(COUNTIF(DARIN!D5,"=A"),SUM(DARIN!C5),0)+IF(COU NTIF(JASMINE!D5,"=A"),SUM(JASMINE!C5),0)
+IF(COUNTIF(DARIN!D6,"=A"),SUM(DARIN!C6),0)+IF(COU NTIF(JASMINE!D6,"=A"),SUM(JASMINE!C6),0)
See how it's an array... there must be a way to shorten it, but I think I
am
using the wrong functions. I've spent several hours tinkering around but
cannot get it to work. The problem is that if you do COUNTIF(D3:D6,"=A"),
if
one item is A, then the whole function is true, causing it to add
incorrectly. Someone HELP! :)
Basically if D3 equals "A", then add C3, if D4 equals "A", then add C4 +
C3,
etc. Not to mention I am pulling the info from 2 different tabs.
|