Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Question
How do I get a formula to automatically update to count the number of times a
changing value exists within the same range of cells? Example: If my range needs to always be B2:F350, how can I count within that range how many times the number 1 appears, then 2, then 3, etc. I have COUNTIF($B$2:$F$350,"=1") but I don't want to have to change the number every time. I want to copy down so the 1 automatically changes to 2 then 3... Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf question | Excel Worksheet Functions | |||
Countif Question | Excel Discussion (Misc queries) | |||
COUNTIF question | Excel Worksheet Functions | |||
COUNTIF question | Excel Worksheet Functions | |||
COUNTIF question | Excel Discussion (Misc queries) |