Sumif and Subtotal not working in google sheets, kindly help

[bhaski0290]

=SUMPRODUCT(SUBTOTAL(9,OFFSET(M8,ROW($M$8:$M$500)-ROW(M8),0)),($F$8:$F$500=F3)+0)

 

[mamady]

It is difficult to replicate the issue you are facing without data set, kindly share a sample using XL2BB

 

[Peter_SSs]

Welcome to the MrExcel board!

You have not had much time to find your way around here but Google sheets questions should be asked in the 'General Discussion & Other Applications forum', not the Excel Questions forum. On this occasion I have moved it for you.

 

[bhaski0290]

It is difficult to replicate the issue you are facing without data set, kindly share a sample using XL2BB

i want to have sumif function with few criteria, but this needs to sum as per filter i do, is there anyway for this ?