Help With Formula

M

mdj0615

I have been trying to get this formula to work, and I just can't get it right.
On sheet 1, I have ten cells from C9 to L9. I'm looking for a formula that
will add up the number of times an A shows up in that range and put it in
cell K3 on another sheet. Any help would be great.
 
S

smartin

mdj0615 said:
I have been trying to get this formula to work, and I just can't get it right.
On sheet 1, I have ten cells from C9 to L9. I'm looking for a formula that
will add up the number of times an A shows up in that range and put it in
cell K3 on another sheet. Any help would be great.
Click to expand...

In K3 on another sheet, try:

=COUNTIF(Sheet1!$C$9:$L$9,"A")
 

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

Copy addition formula of non-consecutive horizontal cells 2
Cumulative formula for word table 0
Newbie Help - IF Yes No Function 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
trouble with (complicated) vlookup searching another workbook 2
Continues to move to the right 0
Look up one value and return multiple corresponding values 2
Dumb question alert! What program to use? 0

Top