I am using:
=SUMPRODUCT(SUBTOTAL(103,OFFSET('Branch mapping'!A4:A1127,ROW('Branch mapping'!A4:A1127)-MIN(ROW('Branch mapping'!A4:A1127)),,1)),--('Branch mapping'!A4:A1127='Branch Summary'!C48))
where C48 has the value of 6, to count the number of times the value 6 occurs in the filtered results of A4:A1127. I have cut and pasted the formula from other cells in the sheet where it works fine on other ranges and and values but with this version I get the answer #DIV/0. Any suggestions why this might be the case.
Have to admit I do not understand how this formula works but it is working elsewhere on the sheet.
Any suggestions most welcome.
=SUMPRODUCT(SUBTOTAL(103,OFFSET('Branch mapping'!A4:A1127,ROW('Branch mapping'!A4:A1127)-MIN(ROW('Branch mapping'!A4:A1127)),,1)),--('Branch mapping'!A4:A1127='Branch Summary'!C48))
where C48 has the value of 6, to count the number of times the value 6 occurs in the filtered results of A4:A1127. I have cut and pasted the formula from other cells in the sheet where it works fine on other ranges and and values but with this version I get the answer #DIV/0. Any suggestions why this might be the case.
Have to admit I do not understand how this formula works but it is working elsewhere on the sheet.
Any suggestions most welcome.