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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Hey,

Try a COUNTIFS function:

=COUNTIFS('Person specification'!B:B,"Essential",'Person specification'!C:C,1)

You can write that in Shortlisting tab and it pulls the information from Person specification tab.
 
Upvote 0
It isn't counting. Does it matter that we're using drop downs?

Drop down won't affect it - so your essential/desirable values & the numbers 1-5 are in the "Person specification" worksheet correct?

It should pull through fine. Do you have your calculation set to manual?
 
Upvote 0
Yep, the essential/desirable values and the numbers 1-5 are in the 'Person specification' worksheet.

How do I know if the calculation is set to manual?
 
Upvote 0
Yep, the essential/desirable values and the numbers 1-5 are in the 'Person specification' worksheet.

How do I know if the calculation is set to manual?

If you go to File -> Options -> Formulas -> Calculation options will list it, change to "Automatic" if it is not already.
 
Upvote 0
I've sent you a PM so we can try sort it out through there - I am not sure why it isn't working for you currently though, so taking a look at the file might be a good idea.

EDIT: Unless you want the following:

=COUNTIF('Person specification'!B:B,"Essential")+COUNTIF('Person specification'!C:C,1)

If that works then I misunderstood from the get-go :laugh:
 
Last edited:
Upvote 0
I can't see where to attach the file...

Any ideas?

I think you have to upload it to dropbox first then link it back here?

Try the formula I edited in my last post; if that doesn't work then see my private message I sent you and we can go from there.
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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