Obtaining sum for multiple criteria
 

I must match criteria in Columns A, B, and E, to get a total revenue from
Column F. I'm going nuts trying to do this. Any ideas?

Obtaining sum for multiple criteria
 

=SUMPRODUCT(--($A$2:$A$200="criteria1"),--($B$2:$B$200="criteria2"),--($E$2:
$E$200="criteria3"),$F$2:$F$00)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Teri" wrote in message
...
I must match criteria in Columns A, B, and E, to get a total revenue from
Column F. I'm going nuts trying to do this. Any ideas?

Obtaining sum for multiple criteria
 

Hi!

Try this:

=SUMPRODUCT(--(A1:A20="criteria1"),--(B1:B20="criteria2"),--(E1:E20="criteria3"),F1:F20)

Better:

G1 = criteria1
G2 = criteria2
G3 = criteria3

=SUMPRODUCT(--(A1:A20=G1),--(B1:B20=G2),--(E1:E20=G3),F1:F20)

Biff

"Teri" wrote in message
...
I must match criteria in Columns A, B, and E, to get a total revenue from
Column F. I'm going nuts trying to do this. Any ideas?

Obtaining sum for multiple criteria
 

Both you guys are awesome! This worked perfectly. Thank you so much and
have a great holiday weekend ;)

"Biff" wrote:

Hi!

Try this:

=SUMPRODUCT(--(A1:A20="criteria1"),--(B1:B20="criteria2"),--(E1:E20="criteria3"),F1:F20)

Better:

G1 = criteria1
G2 = criteria2
G3 = criteria3

=SUMPRODUCT(--(A1:A20=G1),--(B1:B20=G2),--(E1:E20=G3),F1:F20)

Biff

"Teri" wrote in message
...
I must match criteria in Columns A, B, and E, to get a total revenue from
Column F. I'm going nuts trying to do this. Any ideas?

Obtaining sum for multiple criteria
 

Both you guys are awesome!

I can vouch for Bob!

Thanks for the feedback!

Biff

"Teri" wrote in message
...
Both you guys are awesome! This worked perfectly. Thank you so much and
have a great holiday weekend ;)

"Biff" wrote:

Hi!

Try this:

=SUMPRODUCT(--(A1:A20="criteria1"),--(B1:B20="criteria2"),--(E1:E20="criteria3"),F1:F20)

Better:

G1 = criteria1
G2 = criteria2
G3 = criteria3

=SUMPRODUCT(--(A1:A20=G1),--(B1:B20=G2),--(E1:E20=G3),F1:F20)

Biff

"Teri" wrote in message
...
I must match criteria in Columns A, B, and E, to get a total revenue
from
Column F. I'm going nuts trying to do this. Any ideas?