Excel formula help

[Tessie de Wijs]

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!!

[#2]

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

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

[#3]

Already tried that one...

It isn't correct... :(

[#4]

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.

[#5]

Yes, that is what i mean.. but the formula doesn't work...

[#6]

=AANTALLEN.ALS(B2:B350;"1a";E2:E350;"1.laag")

Found it!! Its working now

Thank you very much

[#7]

So far so good. By the way, you may use this great tool https://en.excel-translator.de/translator/ to translate formulas from one language on another

[#8]

Thanks! (was it so bad??)

[#9]

Just that tool helps a lot when you jump from English version to local and back, when you try to adopt English version samples to local code, etc. Saves time and helps to avoid mistakes like using commas instead of semicolons.