Count with two criteria

Originally Posted by DonkeyOte

The formula provided previously does what you want - you may need to alter the delimiters per your locale settings.
I had assumed from your profile that you were in Norway and thus would be using ; delimiter - if not adjust my example as necessary.
(note however in your sample file Col X does not contain any 1.60 values so you will get a 0 output).

Hmm ok sorry mate, my english isn't very good so i don't understand what you mean? I have an english excel version, so 1.60 is in my excel as we say 1,60 in norway. I use a dot instead of a comma in my excel. So in my excel, 1/2 = 0.5 (not 0,5)

Could you please post a formula with english delimiters(?) and i would be very greatful I'm a newbie in Excel, and my english isn't top notch, sorry

Edit: Thanx for the note, but i was just saying the X column to make it simple.
I'm doing the same for
-AA2:AA381
-AD2:AD381
-AG2:AG381
-AJ2:AJ381
-AM2:AM381
-AP2:AP381
-AS2:AS381
-AV2:AV381
-AY2:AY381
It was just to get a formula