Forum Discussion

The Station Hair Studio's avatar
The Station Hair Studio
Copper Contributor
Jan 30, 2019

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond 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)

Resources