mohammad1990
New Member
- Joined
- Mar 2, 2023
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
hi
I have a table and want to use count-if in filter mod i searched and find this formula
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B3:B10,ROW(B3:B10)-ROW(B3),0,1)),--(B3:B10=D2))
it works well but only in one column
when using a range( B3:C10) instead of B3:B10 it doesn't work And gives #Value! error
pleas look the attached file
I have a table and want to use count-if in filter mod i searched and find this formula
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B3:B10,ROW(B3:B10)-ROW(B3),0,1)),--(B3:B10=D2))
it works well but only in one column
when using a range( B3:C10) instead of B3:B10 it doesn't work And gives #Value! error
pleas look the attached file