Sumifs

[Access Beginner]

Hi All,

I have range of cells B21 to N22. I cell B21 is a value of 8 and B22 a value of 9, C21 a value of 7 and C22 a value of 5.

What I'd like is to have is a formula that will sum up the below. I have just used nested If statements ( I know this is not what I'm after, but more so, to give context to my question):

=IF(C22>=C21,1,IF(D22>=D21,1,IF(E22>=E21,1,IF(F22>=F21,1,IF(G22>=G21,1,IF(H22>=H21,1,IF(I22>=I21,1,IF(J22>=J21,1,IF(K22>=K21,1,IF(L22>=L21,1,IF(M22>=M21,1,IF(N22>=N21,1,0))))))))))))

So I'd like to sum all the instances which return the value if 1.

Cheers
Haydn

 

[DanteAmor]

Do you need something like this?

varios 07jul2020.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
21		2	1	4	5	6	2	1	3	5	6	8	9	2		5
22		1	4	2	5	3	1	2	8	3	1	7	9	1
Hoja13

Cell Formulas
Range	Formula
P21	P21	=SUMPRODUCT((B22:N22>=B21:N21)*1)

 

[Access Beginner]

Do you need something like this?

varios 07jul2020.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
21		2	1	4	5	6	2	1	3	5	6	8	9	2		5
22		1	4	2	5	3	1	2	8	3	1	7	9	1
Hoja13

Cell Formulas
Range	Formula
P21	P21	=SUMPRODUCT((B22:N22>=B21:N21)*1)

Hi Dante,

This is exactly what I'm after. Thank you

Cheers
Haydn

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[Access Beginner]

Do you need something like this?

varios 07jul2020.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
21		2	1	4	5	6	2	1	3	5	6	8	9	2		5
22		1	4	2	5	3	1	2	8	3	1	7	9	1
Hoja13

Cell Formulas
Range	Formula
P21	P21	=SUMPRODUCT((B22:N22>=B21:N21)*1)

Hi Dante,

I've just realized if the values in the range is blank it also returns a count of 1, as the condition is met. Is there a way, the formula can be modified to cater for this?