Count with two criteria

**SpareBank1** · 10-06-2009, 10:42 AM

Thanx alot for your help, but still i can't get it to work

I'll add the sheet here, and the actual cells are the ones i mentioned X2:X381 and G2:G381, so you can see for yourself

I tried your formula but it says the formula contains an error. Tried with both COUNTIFS and COUNTIF (couldn't find COUNTIFS in the formula-list). There is a COUNT, a COUNTA, and a COUNTIF. COUNTA is counting number of blank cells.

Heres the file:
http://www.football-data.co.uk/mmz4281/0910/E0.csv

**DonkeyOte** · 10-06-2009, 10:50 AM

OK your profile says you're using XL2007 - if you can't see COUNTIFS I suspect you're actually running an earlier version.

Does the below work ?

=SUMPRODUCT(--(X2:X381=1.60);--(G2:G381="H"))

Going forward please attach files here directly.

**SpareBank1** · 10-06-2009, 11:16 AM

Originally Posted by DonkeyOte

OK your profile says you're using XL2007 - if you can't see COUNTIFS I suspect you're actually running an earlier version.

Does the below work ?

=SUMPRODUCT(--(X2:X381=1.60);--(G2:G381="H"))

Going forward please attach files here directly.

Oh huge mistake by me there. I have the "Office 2007" package, so i expected it was Excel2007, but when i check it it says Microsoft Excel 2002.
Sorry about that

I'll attach the file here:

http://www.football-data.co.uk/mmz4281/0809/E0.csv
Odds in: X2:X381 and Results in G2:G381, as in the example above

**JBeaucaire** · 10-06-2009, 11:21 AM

I have the "Office 2007" package, so i expected it was Excel2007, but when i check it it says Microsoft Excel 2002

Be sure to edit your profile to match.

**DonkeyOte** · 10-06-2009, 11:23 AM

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).

**SpareBank1** · 10-06-2009, 11:27 AM

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