Feb 11 2022 10:29 AM
I am trying to get a formula that will check and see if something is blank. If it is not blank, I want it to return the number of instances in which there is anything present in the reference cell
Unfortunately I am getting a return that spills down rows, rather than one that sums up the number of occurrences.
=IF(INDIRECT("'"&$G$7:INDIRECT("G"&B4)&"'!D61")="",0,SUMPRODUCT(COUNTIF(INDIRECT("'"&$G$7:INDIRECT("G"&B4)&"'!D61"),FALSE)))