I need to update the sumproduct formulas that I am using to correctly display the number of times a date falls within a date range.
Please see the attached example.
On the MFINFO tab, Column C, this is the formula I am using:
))). It looks through the MFDATA tab to see what dates fall where.
Sometimes the dates in column H, Column I and Column N do not fall in the same date range I am specifying. Is there a way to update the SUMPRODUCT formula to use OR so that if one of the dates in columns H,I, & N are within the date range its only going to count it once (of course providing the other criteria in the formula are met) ?
I think if I get that formula updated I can update the other ones.