Forum Discussion
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 2nd and 3rd column. For example from 1st column I want filter Boro rice then filter watermelon from 2nd column and want to know how many Bitter gourd or Sweet gourd in 3rd column. I have large data sheet and just add a small image for an example. Please help to calculate easily changing with filter options with any formula. Please see the below image.
I wait for reply.
Thanks
=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.
4 Replies
=COUNTIFS(first_column, first_item, second_column, second_item, third_column, third_item)
For example:
=COUNTIFS(A2:A1000, "Boro rice", B2:B1000, "Watermelon", C2:C1000, "Bitter gourd")
Instead of "Boro rice" you can use a reference to a cell that contains Boro rice, etc.
- Not working but thanks for your reply. Previous suggestions work.
=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..
