Forum Discussion

Jayanta85's avatar
Jayanta85
Copper Contributor
May 07, 2023
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...
excel
  • OliverScheurich's avatar
    OliverScheurich
    May 07, 2023

    Jayanta85 

    =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.

     

HansVogelaar's avatar
HansVogelaar
MVP
May 07, 2023

Jayanta85 

 

=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.

  • Jayanta85's avatar
    Jayanta85
    Copper Contributor
    May 07, 2023
    Not working but thanks for your reply. Previous suggestions work.