Counting cells

[Anton1983]

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'.

 

[Anton1983]

Did you manage to access my Dropbox link?

 

[Anton1983]

Were you able to access the Dropbox link I sent you?

EDIT: Ignore this post - just saw that my last one went through.

 

[tyija1995]

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.

 

[Fluff]

@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