Thread: Formula Help!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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!