Access Beginner
Active Member
- Joined
- Nov 8, 2010
- Messages
- 311
- Office Version
- 2016
- Platform
- Windows
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):
So I'd like to sum all the instances which return the value if 1.
Cheers
Haydn
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):
Code:
=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