Add range if number is 1 to 10, 11-21,22-30 ...and so
Solved/Closed
Tanuvi
Posts
3
Registration date
Thursday October 4, 2012
Status
Member
Last seen
October 4, 2012
-
Oct 4, 2012 at 02:04 AM
Tanuvi Posts 3 Registration date Thursday October 4, 2012 Status Member Last seen October 4, 2012 - Oct 4, 2012 at 04:59 AM
Tanuvi Posts 3 Registration date Thursday October 4, 2012 Status Member Last seen October 4, 2012 - Oct 4, 2012 at 04:59 AM
Related:
- Add range if number is 1 to 10, 11-21,22-30 ...and so
- Fnaf 1 download pc - Download - Horror
- Gta 1 download - Download - Action and adventure
- Pdf and xps add in 2007 - Download - Other
- Mortal kombat 11 download - Download - Fighting
- Windows 11 tiny iso download - Download - Windows
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 4, 2012 at 03:40 AM
Oct 4, 2012 at 03:40 AM
extremely sorry for 2 mistakes
=SUMIF(A2:A11,">=1",B2:B11)-SUMIF(A2:A11,">10",B2:B111)
=SUMIF(A2:A11,">=1",B2:B11)-SUMIF(A2:A11,">10",B2:B111)
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Oct 4, 2012 at 03:42 AM
Oct 4, 2012 at 03:42 AM
Hi Tanuvi,
There is a worksheet function in Microsoft Excel that can be used. Below formula will fetch you the desired results:
SUM(INDIRECT("B"&C2&":B"&D2))
Follow the step by step instructions mentioned below to use the above formula:
1. Enter the values 1, 2, 3 ... in the cells from A1 to A10.
2. Enter the other set of values 34, 22, 12 ... in the cells from B1 to B10.
3. Enter the labels in the cells as mentioned below:
C1 - Range Start
D1 - Range End
E1 - Range Sum
4. In E2 enter the above Formula.
5. If your range starts at A1 and ends at A5, enter 1 in C2 and 5 in D2, your desired result will be displayed in E2.
You can read more about this formula from the following link:
http://www.cpearson.com/Excel/indirect.htm
Please revert for clarification.
There is a worksheet function in Microsoft Excel that can be used. Below formula will fetch you the desired results:
SUM(INDIRECT("B"&C2&":B"&D2))
Follow the step by step instructions mentioned below to use the above formula:
1. Enter the values 1, 2, 3 ... in the cells from A1 to A10.
2. Enter the other set of values 34, 22, 12 ... in the cells from B1 to B10.
3. Enter the labels in the cells as mentioned below:
C1 - Range Start
D1 - Range End
E1 - Range Sum
4. In E2 enter the above Formula.
5. If your range starts at A1 and ends at A5, enter 1 in C2 and 5 in D2, your desired result will be displayed in E2.
You can read more about this formula from the following link:
http://www.cpearson.com/Excel/indirect.htm
Please revert for clarification.
Tanuvi
Posts
3
Registration date
Thursday October 4, 2012
Status
Member
Last seen
October 4, 2012
Oct 4, 2012 at 04:59 AM
Oct 4, 2012 at 04:59 AM
Hi Zohaib,
Thank you very much.. formula is very helpful..
Thank you very much.. formula is very helpful..
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 4, 2012 at 03:37 AM
Oct 4, 2012 at 03:37 AM
=SUMIF(A2:A11,">=1",B2:B11)-SUMIF(A2:A2,">=10",B2:B12)
mdoify this formula to suit you
mdoify this formula to suit you
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 4, 2012 at 03:38 AM
Oct 4, 2012 at 03:38 AM
slight mistake
=SUMIF(A2:A11,">=1",B2:B11)-SUMIF(A2:A2,">10",B2:B12)
=SUMIF(A2:A11,">=1",B2:B11)-SUMIF(A2:A2,">10",B2:B12)
Oct 4, 2012 at 04:58 AM