Forum Discussion
BeauLytghoe
Feb 11, 2022Copper Contributor
Help with Spill Error in countif using indirect references
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)))
No RepliesBe the first to reply