I am trying to count every row where the date is between the first and last days of a given month, and four other columns contain at least one of various values. I started with COUNTIF, but ran into trouble when it could only handle two OR conditions. Now I'm trying variations on SUMPRODUCT, but I can't get it figured out.
Here is my current formula, which is returning #VALUE!:
And here it is broken apart so you can better read each criteria section:
I've tried using ISNUMBER(MATCH(....with the various criteria too, but I'm not having any luck. Columns H, P, and Q are OR conditions where the value can be any of these. Column K must be Delivery.
I am very grateful for any help you can provide.
Here is my current formula, which is returning #VALUE!:
And here it is broken apart so you can better read each criteria section:
I've tried using ISNUMBER(MATCH(....with the various criteria too, but I'm not having any luck. Columns H, P, and Q are OR conditions where the value can be any of these. Column K must be Delivery.
I am very grateful for any help you can provide.