find active members

[mwvirk]

how i can find if:
cell A1:A500 has the word 'Active' and cell B1:B500 is blank (note: B already has a VLOOKUP)

I have 500 clients where maybe 200 are active and I want to know out of 200 how many are generating commission for me

sorry I don't have a sample sheet for this at this time.

 

[Asbestos_Jen]

If I understand what you want, I would make a table and refer to the column A types as in G&H below:

2024-09-27.xlsx
	A	B	C	D	E	F	G	H
1	Status	Comments	Commission Total	Commission Received	Commission %		Active	33
2	Active						Pending	5
3	Active		33487	13293	39.70%		Block	2
4	Pending						Closed	2
5	Active		5045	2077	41.17%		Total	42
6	Active		4992	2047	41.01%
7	Active		438	180	41.10%
8	Active		30	17	56.67%
9	Block
10	Active		5893	2409	40.88%
11	Active
12	Active
13	Closed
14	Active		7913.06	3087.54	39.02%
15	Pending		11519.11	4515.25	39.20%
16	Active		15125.16	5942.96	39.29%
17	Active		18731.21	7370.67	39.35%
18	Active		22337.27	8798.38	39.39%
19	Active
20	Active		23815.49	9383.65	39.40%
21	Pending		26440.27	10422.85	39.42%
22	Active
23	Active		31689.81	12501.26	39.45%
24	Active		34314.59	13540.46	39.46%
25	Active		36939.36	14579.66	39.47%
26	Active		39564.13	15618.87	39.48%
27	Active
28	Active		44813.68	17697.27	39.49%
29	Active		47438.46	18736.48	39.50%
30	Active		50063.23	19775.68	39.50%
31	Active		52688	20814.88	39.51%
32	Pending
33	Active		57937.55	22893.29	39.51%
34	Active		60562.32	23932.49	39.52%
35	Block		63187.1	24971.7	39.52%
36	Active
37	Active		65811.87	26010.9	39.52%
38	Pending
39	Active		71061.42	28089.31	39.53%
40	Active		73686.19	29128.51	39.53%
41	Closed		76310.96	30167.71	39.53%
42	Active		78935.74	31206.92	39.53%
43	Active		81560.51	32246.12	39.54%
Sheet1

Cell Formulas
Range	Formula
H1:H4	H1	=COUNTIFS($A$1:$A$500,G1,$B$1:$B$500,"")
H5	H5	=SUM(H1:H4)