Forum Discussion
The Station Hair Studio
Jan 30, 2019Copper Contributor
Calculations
Hello,
I am a newbie to Excel. I am trying to add numbers based on the year of number. Meaning I have
11.1.16 1
11.1.17 5
11.1.18 7
11.15.16 2
11.15.17 3
11.15.18 5
there is a long column of numbers, but just like that. I want to add the numbers under xx.x.16 together. Can anyone tell me how to do this? I tried auto sum,but that didn't work. I tried calculate now but that didn't do anything.....
1 Reply
- SergeiBaklanDiamond Contributor
If you mean to sum all numbers in second column against which texts in first column are ended on 16 that could be like
=SUMPRODUCT((RIGHT(A1:A10,2)="16")*$B$1:$B$10)