Formula mod to include AND in Logic

[Walker_Ice]

Hi everyone,

I am trying to modify a formula that works to take into account which employee made the appointments.
The employee name is listed in cell B4 & the column with the employee name is in the range "Income_Artist".

Below you can see the mini table version of what I am working on. Any help would be appreciated. Thank you.

TEsting_Excel_File.xlsx
	A	B	C
3	Appointment Analysis
4	Select Artist:	Bob	2023
5	Month:	# of Appts	Avg price per Appt
6	JAN	0	$ -
7	FEB	1	$ 85.00
8	MAR	0	$ -
9	APR	0	$ -
10	MAY	1	$ 90.00
11	JUN	1	$ 100.00
12	JUL	0	$ -
13	AUG	0	$ -
14	SEP	1	$ 90.00
15	OCT	0	$ -
16	NOV	0	$ -
17	DEC	0	$ -
Sheet4

Cell Formulas
Range	Formula
B6:B17	B6	=IF( $C$4="All", COUNT(FILTER(Income_Dates, MONTH(Income_Dates) = MONTH(DATEVALUE("1-"&TEXT(A6, "mmm")&"-2000")))), COUNT( FILTER( Income_Dates, (MONTH(Income_Dates) = MONTH(DATEVALUE("1-"&TEXT(A6, "mmm")&"-2000"))) * (YEAR(Income_Dates) = $C$4) ) ) )
C6:C17	C6	=IFERROR( IF( $C$4="All", SUM(FILTER(Income_TotalPay, MONTH(Income_Dates) = MONTH(DATEVALUE("1-"&TEXT($A6,"mmm")&"-2000")))) / B6, SUM(FILTER(Income_TotalPay, (MONTH(Income_Dates) = MONTH(DATEVALUE("1-"&TEXT($A6,"mmm")&"-2000"))) * (YEAR(Income_Dates) = $C$4))) / B6 ), 0 )

Named Ranges
Name	Refers To	Cells
Income_Dates	=Sheet2!$A$2:$A$8	B6:C17
Income_TotalPay	=Sheet2!$D$2:$D$8	C6:C17

Cells with Data Validation
Cell	Allow	Criteria
B4	List	Joe,Bob,Steve

 

[SanjayGMusafir]

COUNT(FILTER(Income_Dates, MONTH(Income_Dates) = MONTH(DATEVALUE("1-"&TEXT(A6, "mmm")&"-2000"))))

Are you looking for this? Actually your question is bit unclear -

COUNT(FILTER(Income_Dates, (MONTH(Income_Dates) = MONTH(DATEVALUE("1-"&TEXT(A6, "mmm")&"-2000")))*(Income_Artist=$B$4)))