Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Count cell value if that pattern matches with two columns in google sheet

enter image description hereHow do I find the count of an value based on condition on two columns?

Here is an example:
So Column E2 and E3 has count 1 and 2 respectively because of number of available Mango and Grapes in row C.
example

I tired some formulas with count and countif, It did not work.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

You may try this in Cell_E2:

=countifs(B:B,D2,C:C,"Available")
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading