Hi there, I am hoping someone can help,
I have the following data with a filter applied in A4 & B4
A3 is currently calculated with =SUBTOTAL(9,A5:A13).
Does anyone know how I can calculate the subtotal in B3 of column A5:A13, if the corresponding cell in B5:B13 is not blank?
In this example B3 would = 548
Any help eternally appreciated,
CF
I have the following data with a filter applied in A4 & B4
A3 is currently calculated with =SUBTOTAL(9,A5:A13).
Does anyone know how I can calculate the subtotal in B3 of column A5:A13, if the corresponding cell in B5:B13 is not blank?
In this example B3 would = 548
Any help eternally appreciated,
CF