|OK, I'm confused.|
If Column D5:D45 = HYD, column E5:E45= 5, I need to count columns G5 thru I45 if it contains R
D5:D45, E5:E45 and G5 thru I45 are not columns, they are ranges.
Do mean "for each cell in those ranges that equal those values" or do you mean "if those entire ranges equal those values"?
You also described what you want to do and then said:
I have built a SUMPRODUCT formula that will do all the above except the daily count
Since the daily count was included in your requirements "above", what all does the SUMPRODUCT formula that you built actually do?
Why not include the formula for us to see?
Perhaps it would help if you gave us some examples of inputs and expected outputs so we can see what you are trying to do.
Use the pre tags found above the Reply box to help line up your data.