Forum Discussion

Tessie de Wijs's avatar
Tessie de Wijs
Copper Contributor
Sep 04, 2018

Excel formula help

Hope i can explain it proper in english

I'd like to count the cell in kolom B and D which has the same information

=AANTAL.ALS(B2:B350;"1a",E2:E350;"1.Laag")  (sorry dutch formula)

Whats wrong with my formula?

Thank you all!!

 

Formulas and Functions

8 Replies

  • Philip West's avatar
    Philip West
    Iron Contributor
    Sep 04, 2018

    Not sure about the dutch name, but try a countifs.. something like:

     

    =COUNTIFS(B2:B350,"1a",E2:E350,"1.laag")

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Sep 04, 2018

        Formula correct if you mean AND condition, i.e. count all where simultaneously 1a in B and 1.laag in E for the same row. As attached.

Resources