New to the forum

[bogey69]

Live in PA, Mostly been designing golf programs in excel for leagues. Always trying to find easier methods of using functions and formulas. Will help anytime I can.

[vlady]

Welcome to the community of Excellers

[grambo]

Hello Bogey69.
I run a golf money pool and am wondering if there is an easier formula for getting what I want.
I am attaching an example. I copy from the PGATour.com and input data into the POOLWS
This is then copied to Weekly and Yearly sheets. I then use this formula to get the results from Column B into Column Attachment 311378A
=IF(SUMPRODUCT(--(D1=$A$1:$A$281))<>0,SUMPRODUCT(--(D1=$A$1:$A$281),$B$1:$B$281),"")
I also use this formula on the Main Sheet for the players earnings.
I do TRIM from the net but am starting to get many errors with this formula.
Just wondering if you have any suggestions or better ways of doing what I am doing.
Thanks Graham
Example.xlsm

[arlu1201]

Welcome grambo. You need to post your question in the formulas subforum.

[bogey69]

Hi Grambo,
Don't think I can help much on your spreadsheet, I will look into it and see if I can come up with a better formula.
What are the errors you get?
Bogey69

[vlady]

@ grambo

You can create a new thread in the "Excel Formulas / Function " section for discussions.

Thanks.