Creating a formula that counts occurances

S

smoutsat

If cells AG3 through AW3 can have a 1, 2, 3, 4, or 5 code entered. What
formula is needed for cell AX3, if I want to count the number of times a 1
was noted/occurred in cells AG3 through AW3?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct Across A Row 11
Comparing data intervals 4
Calculated values in a cell 5
Remove Identical words 0
Split cells next to 1 cell 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
attendance based pay for Army reserve 3
Using FIND to highlight text (with dashes) 4

Top