Im trying to count the number of boxes that have the same colour background in a column from rows A-K. Alternatively trying to count the names of people from a list that occur from rows A-K. will need to repeat this 99 times for each column
Im trying to count the number of boxes that have the same colour background in a column from rows A-K. Alternatively trying to count the names of people from a list that occur from rows A-K. will need to repeat this 99 times for each column
Last edited by 20131324; 10-17-2019 at 08:47 PM.
You can't count colours using a formula, but you can count names using the COUNTIF or COUNTIFS functions. There is not enough detail in your post for me to suggest a likely formula, though, so it would help if you attached a sample Excel workbook.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Don't try to use the Paperclip icon, as it doesn't work on this forum.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks