Counting cells

Anton1983

New Member
Joined
Mar 9, 2018
Messages
17
Hello,

In one column (B), users can choose between 'Essential' and 'Desirable'. In another column (C), users can choose between 1 and 5. Do you have a formula for counting the numbers of Essentials in column B and the number of 1s in column C, etc.? It's one formula I need, for doing both, e.g. The number of essentials AND the number of 1s.

Columns B and C, where the data we want to count is, is in a tab called 'Person specification', but we are counting from another tab, 'Shortlisting'.
 
Last edited:

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Were you able to access the Dropbox link I sent you?

EDIT: Ignore this post - just saw that my last one went through.
 
Last edited:
Upvote 0
Hey,

I've looked through it and there were a few things I noticed as to why it wasn't working - I'll send it back in a PM now with feedback too on some of the issues I saw.
 
Upvote 0
@tyija1995 and @Anton1983

As per forum rules, please keep all communications in the thread, not via the PM system.


@Anton1983
Please post a link to your file in the thread
Thanks
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top