someone please shorten this formula...

[wildwheelz]

It's hard to describe what I am doing, but here's my formula...

=IF(COUNTIF(DARIN!D3,"=A"),SUM(DARIN!C3),0)+IF(COUNTIF(JASMINE!D3,"=A"),SUM(JASMINE!C3),0
+IF(COUNTIF(DARIN!D4,"=A"),SUM(DARIN!C4),0)+IF(COUNTIF(JASMINE!D4,"=A"),SUM(JASMINE!C4),0
+IF(COUNTIF(DARIN!D5,"=A"),SUM(DARIN!C5),0)+IF(COUNTIF(JASMINE!D5,"=A"),SUM(JASMINE!C5),0
+IF(COUNTIF(DARIN!D6,"=A"),SUM(DARIN!C6),0)+IF(COUNTIF(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(D36,"=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.

 

[Fred Smith]

How about:
=sumif(darin!d3:d6,"A",darin!c3:c6)+sumif(jasmine!d3:d6,"A",jasmine!c3:c6)

Regards,
Fred

 

[T. Valko]

This will do what your current formula is doing. Whether that's what you
really want is another story!

=SUMIF(DARIN!D36,"A",DARIN!C3:C6)+SUMIF(JASMINE!D36,"A",JASMINE!C3:C6)

 

[wildwheelz]

THANKS! I tried using that function but didn't quite get it.... you guys
rock! They probably call you experts

 

[wildwheelz]

Works exactly how I want it to... thanks! I am making a guest list for an
upcoming wedding and I have an A,B,C priority list + number of guests (a
couple would be 2 people). On my summary page, I wanted to list how many A's,
B's, C's are listed... so thanks!!

 

[Fred Smith]

Glad to help. Thanks for the feedback.

Regards,
Fred

 

[T. Valko]

You're welcome. Thanks for the feedback!