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?

=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?

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?

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?

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?