COUNTIF Issues - Counting across columns

[DSL1970]

All,

I have struggling with a formula to use IF and AND. I have 3 columns in a table, Chain of Command 1, Chain of Command 2 and a Full Time/Part Time column. This list will be added to each week, so it will continue to grow.

Based on a preselected Leader I have been able to get a count of on many times a leader shows up in the list, but I haven't been able to determine how I only use this leader and determine how many are FT employees. This number can only be equal to or less than the count - which makes sense. So listed below I have the correct count formula, but struggling on getting the count of FT based on the leader (including my 40th attempt to get this to work!!!). Any help is appreciated

Which Leader?	Count
LEADER 1	=COUNTIF(A5:B24,A2)	=COUNTIF(AND((A5:B24,A2), C5:C24="FT"),COUNTIF( C5:C24="FT"),"")
CHAIN OF COMMAND 1	CHAIN OF COMMAND 2	PT/FT
LEADER 1	LEADER 19	FT
LEADER 1	LEADER 20	FT
LEADER 1	LEADER 21	PT
LEADER 2	LEADER 22	FT
LEADER 3	LEADER 23	FT
LEADER 4	LEADER 24	FT
LEADER 5	LEADER 25	FT
LEADER 6	LEADER 26	FT
LEADER 7	LEADER 27	FT
LEADER 8	LEADER 28	FT
LEADER 9	LEADER 29	FT
LEADER 10	LEADER 30	FT
LEADER 11	LEADER 31	FT
LEADER 12	LEADER 32	FT
LEADER 13	LEADER 33	FT
LEADER 14	LEADER 34	FT
LEADER 15	LEADER 35	FT
LEADER 16	LEADER 36	FT
LEADER 17	LEADER 37	FT
LEADER 18	LEADER 38	FT

<tbody>
</tbody>

 

[Momentman]

COUNTIFS

Book1
	A	B	C
1	LEADER 1	FT	2
2
3	CHAIN OF COMMAND 1	CHAIN OF COMMAND 2	PT/FT
4	LEADER 1	LEADER 19	FT
5	LEADER 1	LEADER 20	FT
6	LEADER 1	LEADER 21	PT
7	LEADER 2	LEADER 22	FT
8	LEADER 3	LEADER 23	FT
9	LEADER 4	LEADER 24	FT
10	LEADER 5	LEADER 25	FT
11	LEADER 6	LEADER 26	FT
12	LEADER 7	LEADER 27	FT
13	LEADER 8	LEADER 28	FT
14	LEADER 9	LEADER 29	FT
15	LEADER 10	LEADER 30	FT
16	LEADER 11	LEADER 31	FT
17	LEADER 12	LEADER 32	FT
18	LEADER 13	LEADER 33	FT
19	LEADER 14	LEADER 34	FT
Sheet3

Cell Formulas
Range	Formula
C1	=COUNTIFS($A$4:$A$23,$A$1,$C$4:$C$23,$B$1)

 

[jtakw]

Hi,

Also posted here: https://www.mrexcel.com/forum/excel...ng-across-columns.html?highlight=#post5040170