Search results

Thanks that did the trick :) Just out of curiosity i don;t suppose there's a way to combine the 2 SUMPRODUCT statements in to 1....?? =SUMPRODUCT(--(F2:F236="never"),SUBTOTAL(103,OFFSET(F2,ROW(F2:F236)-ROW(F2),0))) and...

Thanks for that! - it works but it displays ######## in the cell but when i hover over the cell with the mouse it brings up 67 which is correct. is there a way to get the number to display in the cell.....??? Thansk again

Hi All trying to use a SUMPRODUCT to to total the amount of times "never" or "quit" appears in a column. Only problem is "quit" is a partial string so it can include "quit >5years" or "quit <5years" Note - i am using =SUBTOTAL(103,B2) in A2 so when i filter by different sites it only...