using countif in isolated cells not a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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 :-)
------------------------------­------------------------------­----------------
 
You must log in or register to reply here.

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

Counting text problem - formula works initially 3
countif where condition should be met 3
Multiple arguments 1
Text to number value 1
Count range of cells if not next to each other 0
Amazon are rubbish 14
Countif contains a word in a reference cell 3
Assign a code to a range of time 15

Back
Top