Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Note: Mine assumes that the criteria you're looking to count remains in place
on the DATA tab. bpeltzer's formula assumes you've moved the criteria onto that cell on the LIST tab. "Eric" wrote: On LIST: =COUNTIF(DATA!E2:E50000,DATA!I2) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A question about the Count/CountIf function | Excel Worksheet Functions | |||
Reading data from another sheet where data is in variable cells | Excel Discussion (Misc queries) | |||
How do I display this data in a differnet format? | Excel Discussion (Misc queries) | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
Countif/Sumif function question | Excel Worksheet Functions |