| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
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") -- Kevin Backmann "Darcy" wrote: 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??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
will this work if there are a, r, and q's throughout the sheet??
"Kevin B" wrote: 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") -- Kevin Backmann "Darcy" wrote: 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??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
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") -- Kevin Backmann "Darcy" wrote: will this work if there are a, r, and q's throughout the sheet?? "Kevin B" wrote: 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") -- Kevin Backmann "Darcy" wrote: 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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
