Hi all
I was hoping someone would be able to help me with using sumproduct as a replacement for countifs on closed workbooks. I've been able to get it to work for when I have countif, but seem to be making a silly mistake with countifs.
My original formula is:
=(COUNTIFS('[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$F$4:$F$264,"<>",'[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$M$4:$M$264,">-1"))/$C4
Is there a way to do this with sumproduct?
Thank you so much for any help!
I was hoping someone would be able to help me with using sumproduct as a replacement for countifs on closed workbooks. I've been able to get it to work for when I have countif, but seem to be making a silly mistake with countifs.
My original formula is:
=(COUNTIFS('[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$F$4:$F$264,"<>",'[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$M$4:$M$264,">-1"))/$C4
Is there a way to do this with sumproduct?
Thank you so much for any help!