Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using countif in isolated cells not a range
I know how to use countif in a range but what if I want to add text in a big
spreadsheet when the text is not in a range so I can total how many supervisors are sched for pm's? A B C 1 Shift Classification Supervisor 2 day orientee 3 pm orientee 4 pm S 4 day S 5 pm S |
#2
|
|||
|
|||
=SUMPRODUCT(--(A1:A100="PM"),--(C1:C100="Supervisor"))
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "ferde" wrote in message ... I know how to use countif in a range but what if I want to add text in a big spreadsheet when the text is not in a range so I can total how many supervisors are sched for pm's? A B C 1 Shift Classification Supervisor 2 day orientee 3 pm orientee 4 pm S 4 day S 5 pm S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count occurances in range of cells | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions |