hello,
i want to combine this 2 formula at google sheet ( online ),
sumif($D$7:$D$229,$F235,Q$7:Q$229) & subtotal(9,Q$7:Q$229)
i use this formula at excel & work : SUMPRODUCT(SUBTOTAL(9,OFFSET($Q$7,ROW($Q$7:$Q$229)-ROW($Q$7),0,1)),--($D$7:$D$229=$F235))
but when upload to google sheet = #VALUE!
need help what wrong with the formula at google sheet ?
i want to combine this 2 formula at google sheet ( online ),
sumif($D$7:$D$229,$F235,Q$7:Q$229) & subtotal(9,Q$7:Q$229)
i use this formula at excel & work : SUMPRODUCT(SUBTOTAL(9,OFFSET($Q$7,ROW($Q$7:$Q$229)-ROW($Q$7),0,1)),--($D$7:$D$229=$F235))
but when upload to google sheet = #VALUE!
need help what wrong with the formula at google sheet ?