Sum a range of values only if it has certain value
Closed
Suranjith
Zohaib R
- Posts
- 2
- Registration date
- Thursday April 25, 2013
- Status
- Member
- Last seen
- April 26, 2013
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Sum a range of values only if it has certain value
- Excel if function range of values - Guide
- Excel Total Range of Values ✓ - Forum - Office Software
- Vba deleting rows that do not contain set values defined in range ✓ - Forum - Excel
- Excel vba userform combobox values from range - Guide
- How to sum a number from a range of cells, based on value ✓ - Forum - Excel
2 replies
Zohaib R
Apr 26, 2013 at 05:18 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Apr 26, 2013 at 05:18 AM
Hi Suranjith,
I have tried the following, check if this helps:
I have changed the dates from the below mentioned format:
19810101
To:
1/1/1981
Using the formula:
=VALUE(LEFT(A2,4)&"/"&RIGHT(LEFT(A2,6),2)&"/"&RIGHT(A2,2))
Then, using the formula:
=SUMIF($E$2:$E$60,H2,$B$2:$B$60)
I have calculated the Rain in CMs for the corresponding month.
You can download the sample sheet from the below mentioned link:
http://speedy.sh/HUpUK/RaininCMs.xlsx
Please revert for clarification.
I have tried the following, check if this helps:
I have changed the dates from the below mentioned format:
19810101
To:
1/1/1981
Using the formula:
=VALUE(LEFT(A2,4)&"/"&RIGHT(LEFT(A2,6),2)&"/"&RIGHT(A2,2))
Then, using the formula:
=SUMIF($E$2:$E$60,H2,$B$2:$B$60)
I have calculated the Rain in CMs for the corresponding month.
You can download the sample sheet from the below mentioned link:
http://speedy.sh/HUpUK/RaininCMs.xlsx
Please revert for clarification.
Zohaib R
Apr 26, 2013 at 06:21 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Apr 26, 2013 at 06:21 AM
Hi Suranjith,
Thank for you kind response. I am glad to know you found my method interesting. Please feel free to get back to us if you have any further queries.
Thank for you kind response. I am glad to know you found my method interesting. Please feel free to get back to us if you have any further queries.
Apr 26, 2013 at 05:55 AM