Help with Spill Error in countif using indirect references

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3155893%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHelp%20with%20Spill%20Error%20in%20countif%20using%20indirect%20references%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3155893%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20am%20trying%20to%20get%20a%20formula%20that%20will%20check%20and%20see%20if%20something%20is%20blank.%20If%20it%20is%20not%20blank%2C%20I%20want%20it%20to%20return%20the%20number%20of%20instances%20in%20which%20there%20is%20anything%20present%20in%20the%20reference%20cell%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EUnfortunately%20I%20am%20getting%20a%20return%20that%20spills%20down%20rows%2C%20rather%20than%20one%20that%20sums%20up%20the%20number%20of%20occurrences.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3DIF(INDIRECT(%22'%22%26amp%3B%24G%247%3AINDIRECT(%22G%22%26amp%3BB4)%26amp%3B%22'!D61%22)%3D%22%22%2C0%2CSUMPRODUCT(COUNTIF(INDIRECT(%22'%22%26amp%3B%24G%247%3AINDIRECT(%22G%22%26amp%3BB4)%26amp%3B%22'!D61%22)%2CFALSE)))%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3155893%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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)))

0 Replies