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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks