General discussion

Locked

Calculating a certain value?

By TobeJ ·
Hi there,

Need some help in excel spread sheet. If I
have say cells A4 - A12 and they either have a 1 or 2, and I want to count how many #1 seperate from how many #2there are. So I need to find out if there are 8 #1 or 4 #2 marked between A4 - A12.

Thanks for the help.

Toby

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Calculating a certain value?

by skinnerj In reply to Calculating a certain va ...

In excel go to insert function.
The function you want to use is:
Statistcal/Countif it will give you a some of all number ones or twos. In order to do both you will need to use 2 different cells

Collapse -

Calculating a certain value?

by TobeJ In reply to Calculating a certain va ...

Perfect thanks for the help.

Have a good day.

Toby

Collapse -

Calculating a certain value?

by TobeJ In reply to Calculating a certain va ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Software Forums