P
PAL
I have these two formulas below working great. I have been asked to modify
it by doing the calculation for a period greater than one month. I currently
identify the month by, "TEXT(G17,"mmyyyy")". How do I modify this to
calculate if the data is between two dates. Thanks.
=COUNT(IF(TEXT(Work!$N$3:$N$5724,"mmyyyy")=TEXT(G17,"mmyyyy"),IF(Work!$O$3:$O$5724="",Work!$O$3:$O$5724)))
=AVERAGE(IF(TEXT(Work!$N$3:$N$5724,"mmyyyy")=TEXT(G17,"mmyyyy"),IF(Work!$O$3:$O$5724<>"",Work!$B$3:$B$5724)))
it by doing the calculation for a period greater than one month. I currently
identify the month by, "TEXT(G17,"mmyyyy")". How do I modify this to
calculate if the data is between two dates. Thanks.
=COUNT(IF(TEXT(Work!$N$3:$N$5724,"mmyyyy")=TEXT(G17,"mmyyyy"),IF(Work!$O$3:$O$5724="",Work!$O$3:$O$5724)))
=AVERAGE(IF(TEXT(Work!$N$3:$N$5724,"mmyyyy")=TEXT(G17,"mmyyyy"),IF(Work!$O$3:$O$5724<>"",Work!$B$3:$B$5724)))