The Station Hair Studio
Occasional Visitor


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

If you mean to sum all numbers in second column against which texts in first column are ended on 16 that could be like

Related Conversations
Creating a form with calculations
HimanshuS87 in Microsoft Forms on
1 Replies