Happy New Year to everyone,
It has been a while but need assistance in figuring % of cells in a spreadsheet total based on colors. See attached and thank you all for the assistance.
Regards, EJ
Happy New Year to everyone,
It has been a while but need assistance in figuring % of cells in a spreadsheet total based on colors. See attached and thank you all for the assistance.
Regards, EJ
Last edited by bigdukesix; 01-18-2016 at 05:25 PM.
In E2, enter =COUNTIF($B$2:$B$200,D2)/COUNTA($B$2:$B$200) then fill the formula.
Thank you JieJenn...![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks