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.