Hi everyone,
In the formula below I used sumproduct function twice to count the items which are marked "N/A" in column E or "Completed" in column G. Items to be counted would also have a date recorded in column F.
Can this be combined into one sumproduct formula?
Thanks in advance.
In the formula below I used sumproduct function twice to count the items which are marked "N/A" in column E or "Completed" in column G. Items to be counted would also have a date recorded in column F.
HTML:
=SUMPRODUCT((Sheet1!F4:F65536>0)*(Sheet1!E4:E65536="N/A"))+SUMPRODUCT((Sheet1!F4:F65536>0)*(Sheet1!G4:G65536="Completed"))
Can this be combined into one sumproduct formula?
Thanks in advance.