VBA code for Countifs when there are 3 conditions

[NoxGalleon106]

Hi,

I am working on a macro wherein it should count the number of cells that meets the following 3 criteria:

1. Range N:N is > 5,000,000
2. Range AE = To prematch
3. Range J:J = next business day

My current codes are as follows but I am not sure on how to integrate the 3 codes. The

SD = Application.WorkDay(Date, 1)
SD1 = Format(SD, "dd\/mm\/yyyy")
B = WorksheetFunction.CountIf(Range("AE:AE"), "To Prematch")
T = WorksheetFunction.CountIf(Range("J:J"), "=" & SD)
H = WorksheetFunction.CountIf(Range("N:N"), ">" & 5000000)

Thanks in advance!

 

[NARAYANK991]

Hi ,

To count using more than one criterion , you will have to use the COUNTIFS function , as follows :

WorksheetFunction.CountIfs(Range("N:N"), ">5000000" , Range("AE:AE"), "To Prematch" , Range("J:J"), "=" & Format(Application.WorkDay(Date, 1), "dd\/mm\/yyyy"))

 

[NoxGalleon106]

Hi ,

To count using more than one criterion , you will have to use the COUNTIFS function , as follows :

WorksheetFunction.CountIfs(Range("N:N"), ">5000000" , Range("AE:AE"), "To Prematch" , Range("J:J"), "=" & Format(Application.WorkDay(Date, 1), "dd\/mm\/yyyy"))

Brill! worked like a charm. Thank you!