Forum Discussion
Solved
Need help for formula
I want to filter one from 1st column and then filter 2nd column and want to know the specific number in 3rd column automatically. Can I use any formula to automatically count the specific item from 2...
=SUMPRODUCT(($A$2:$A$19=E9)*($B$2:$B$19=F9)*(($C$2:$C$19=G9)+($C$2:$C$19=G10)))You can try this formula. The ranges can be adapted as required.
=SUMPRODUCT(($A$2:$A$19=E9)*($B$2:$B$19=F9)*(($C$2:$C$19=G9)+($C$2:$C$19=G10)))You can try this formula. The ranges can be adapted as required.
Thank you very much for your help. It really works. I tried earlier with SUMPRODUCT formula but may be wrong condition I applied.
Thanks again and will look forward for next help..
Thanks again and will look forward for next help..