LinkBack URL
About LinkBacks
Hi guys - would anyone please help on this? I have attached a question that I am working on.
Thank you very much.
Hi guys - would anyone please help on this? I have attached a question that I am working on.
Thank you very much.
Hi, welcome to the forum
TRy this...
=SUMPRODUCT(--(LEFT(B3:B7,1))/COUNTA(B3:B7))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbins,
I did not think of that, simply brilliant- and a Palm in hand moment...
I was going here...
=SUM(COUNTIFS($B$3:$B$9,"*1*"),COUNTIFS($B$3:$B$9,"*2*")*2,COUNTIFS($B$3:$B$9,"*3*")*3,COUNTIFS($B$3:$B$9,"*4*")*4,COUNTIFS($B$3:$B$9,"*5*")*5)/SUM(COUNTIFS($B$3:$B$9,"*1*"),COUNTIFS($B$3:$B$9,"*2*"),COUNTIFS($B$3:$B$9,"*3*"),COUNTIFS($B$3:$B$9,"*4*"),COUNTIFS($B$3:$B$9,"*5*"))
-If you think you are done, Start over - ELeGault
Cool. Thank you very much @FDibbins
Happy to help, and thanks for the kind words. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Marked SOLVED as suggested. Thanks FDibbins.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks