MartinS
Active Member
- Joined
- Jun 17, 2003
- Messages
- 487
- Office Version
- 365
- Platform
- Windows
OK, hope the title makes sense.
I have a blovk of data, and i want to sum, for the first row, columns B to AT (ages 16 to 60), but for the next row, 16 to 59, and so on.
I have a row of ages above the data (16 to 110) which can be used in a SUMIF formulae, but am just not sure about the criteria for an age range.
Can anyone help please?
Thanks
Martin
I have a blovk of data, and i want to sum, for the first row, columns B to AT (ages 16 to 60), but for the next row, 16 to 59, and so on.
I have a row of ages above the data (16 to 110) which can be used in a SUMIF formulae, but am just not sure about the criteria for an age range.
Can anyone help please?
Thanks
Martin