Formulas

D

Darcy

Desprately need help ASAP.

I am trying to to set up a spreadsheet that allows for tracking of assigned,
requested, and received. Using the letters A, R, Q. How do I make the one
cell count all the assigned cells and requested cells and so. Do I need to
change the value of the letters and if so how???
 
K

Kevin B

Use the following formulas,changing the range of A1:A8 to match the range in
your worksheet:

1. =COUNTIF(A1:A8,"=A")
2. =COUNTIF(A1:A8,"=R")
3. =COUNTIF(A1:A8,"=Q")
 
K

Kevin B

If you need to include multiple non-contiguous ranges you can enter something
along the following lines:

=COUNTIF(A1:A10:D1:D10:G1:G10,"=A")
=COUNTIF(A1:A10:D1:D10:G1:G10,"=Q")
=COUNTIF(A1:A10:D1:D10:G1:G10,"=R")
 

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

Need formulas to return multiple data matches 1
Split Cell Range into Multiple Cells 1
Counting Letters 2
Excel Add ^ to a row of cells containing letters 3
Excel Countif cell has diagonal border 6
how do i remove the 0 in the cells 6
Column chngd fm letters to numbers. What that & how do I go back? 1
How to create a list of permutations and combinations? 2

Top