Forum Discussion
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 wit...
Not sure about the dutch name, but try a countifs.. something like:
=COUNTIFS(B2:B350,"1a",E2:E350,"1.laag")
Already tried that one...
It isn't correct... :(
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.
Yes, that is what i mean.. but the formula doesn't work...
=AANTALLEN.ALS(B2:B350;"1a";E2:E350;"1.laag")
Found it!! Its working now
Thank you very much
