Sumif for a whole row of data

[SM mechanic]

Row 1 has 12 columns for months of the year. Row 2 is a number, which equates to a score. from 1.00 to 5.00 which is the score for the whole district. Row 3 is our score, from 1.00 to 5.00
I would like to have 2 cells that performs a count if type function, 1 cell would track the number of times we were above the district number, and the other cell would total up the number of times we were at or below the district score.

So for example, and the end of the year once I have all the months filled in, one cell will show we beat the district score 8 months, and we equaled or missed the district score 4 times.

I can do it for one month, I can't figure out how to do it for multiple months.

Here is an example of what it would look like on my sheet. The cells that calculate are the ones under the Won, Lost cells

Hope this makes sense, for what I am trying to do.

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sept

Oct

Nov

Dec

Won

Lost

District

4.88​

4.92

4.86

4.35

4.85

Store

4.87​

4.91

4.87

4.52

4.85

2​

3​

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sept	Oct	Nov	Dec		Won	Lost
2	District	4.88	4.92	4.86	4.35	4.85
3	Store	4.87	4.91	4.87	4.52	4.85									2	3
Data

Cell Formulas
Range	Formula
O3	O3	=SUMPRODUCT(--(B3:N3>B2:N2))
P3	P3	=COUNT(B3:N3)-O3

 

[SM mechanic]

I updated my account details. My apologies for not having them filled out. Makes sense anyone offering help would need that info.

 

[Fluff]

Thanks for that.
Did the formulae I suggested work?

 

[SM mechanic]

Thank you Fluff, that worked perfectly. I did click the "solved" button. Took a few minutes for me to put it into my sheet. But it is working exactly like I was looking for.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[SM mechanic]

Glad to help & thanks for the feedback.

Can your formulas be amended to return a blank cell if there is a zero in it?

I tried this, but I am getting a error message

=if(COUNT(B11:N11)-O11)=0,"",count(B11:n11)-O11))

 

[Fluff]

You can use a custom format on the cells with 0;-0;;@ which will display a blank cell instead of 0

 

[SM mechanic]

Thank you I will do that

 

[Fluff]

You're welcome.