someone please shorten this formula...
 

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.

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.

someone please shorten this formula...
 

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

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

--
Biff
Microsoft Excel MVP


"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.

someone please shorten this formula...
 

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

someone please shorten this formula...
 

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!!

someone please shorten this formula...
 

Glad to help. Thanks for the feedback.

Regards,
Fred

"wildwheelz" wrote in message
...
THANKS! I tried using that function but didn't quite get it.... you guys
rock! They probably call you experts :)

someone please shorten this formula...
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"wildwheelz" wrote in message
...
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!!