Sum a range of values only if it has certain value
Closed
Suranjith
Posts
2
Registration date
Thursday April 25, 2013
Status
Member
Last seen
April 26, 2013
-
Apr 25, 2013 at 07:17 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 26, 2013 at 06:21 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 26, 2013 at 06:21 AM
Related:
- Sum a range of values only if it has certain value
- Apple airtag range - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Clear cell contents based on value of another cell range using VBA ✓ - Excel Forum
- Sum sum disney - Download - Puzzle
2 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 26, 2013 at 05:18 AM
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
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 26, 2013 at 06:21 AM
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