Formula Help!
=COUNTIF($C51:$AJ51,B41)/SUMPRODUCT((ISNUMBER(MATCH($C$51:$AJ$52,$B$41:$B$4 2,0)))*($C$41:$AJ$420))*F$3
will get the first name value
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Killer" wrote in message
...
Can anyone help me on this formula?
"Killer" wrote:
Hey Bob thanks for the help but that doesn't work.
=SUMPRODUCT(--(C$51:AJ$51=B41),--(C41:AJ410))*F$3
The formula above works only if a person names is in cell C$51:AJ$51 but
doesn't take into count if a second person name is showing in cells
C$52:AJ$52
If two people names are showing say S51 &S52 then the result should be a
split of the amount in cell F3 towards each person name in S51 &S52
I hope this more clearly.
Thanks for the Help!
"Bob Phillips" wrote:
How about
=$F$3/SUMPRODUCT(--(C$51:AJ$51=B41),--(C41:AJ410))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Killer" wrote in message
...
I have spreadsheet with the following:
F3 = $175
This formula
=SUMPRODUCT(--(C$51:AJ$51=B41),--(C41:AJ410))*F$3
Returns a result whoever has the highest would win $175 but now there
might
be a second person involved based on a tie, if there is then the pot
should
be split in half between the two people.
Winners names are located in C51: AJ51 & C52 : AJ52
Thanks!
|