You need to know how many clients you have in a dataset with these fields in these ranges. Criteria are in A$363$:F$365.$

ClientID A$4$:A$357$

ClientName B$4$:B$357$

OrderDate C$4$:C$357$

Item D$4$:D$357$

Quantity E$4$:E$357$

Price F$4$:F$357$

Which function would accomplish this task?

A$)$ DCOUNT$($A$6$:F$357,$A$3,$A$363$:F$365)$

B$)$ DCOUNT$($A$6$:F$357,$A$365$:F$363$:G$365)$

C$)$ DMIN$($A$6$:F$357,$G$365,$A$363$:F$365)$

D$)$ DMAX$($A$6$:F$357,$G$365,$A$363$:F$365)$