1

I have a Google Sheet of data like this:

4/1/17 | 5
4/1/17 | 7
4/1/17 | 22
4/2/17 | 5
4/2/17 | 10
4/3/17 | 5
4/3/17 | 23
4/3/17 | 1
4/3/17 | 5
4/3/17 | 17
4/3/17 | 3

And I want some sort of formula that I can apply to this range to return this:

4/1/17 | 34
4/2/17 | 15
4/3/17 | 54

(Obviously any date can have any number of entries and it needs to be expandable so that another date can be added - e.g. 4/4/17 - and the "result range" will automatically populate a new row)

Any suggestions?

1

If your data is in ColumnsA:B then your first date in say D1 and in E1:

=sumif(A:A,D1,B:B)

is not fully automatic (you would have to drag D1:E1 down to suit) but should give the desired output. Provided dragged far enough further data added to B:C should update D:E.

  • Is there any way to have a formula that is "fully automatic" (such that it finds the unique dates and populates the "D" column for me?) – derekantrican Apr 11 '17 at 19:43
  • Great! It's a shame that the SUMIF rows will just have to "sit there" until that date gets entered, but I guess there isn't a better option? Thanks! – derekantrican Apr 11 '17 at 19:50
  • What other details would you like? I can provide whatever information you need – derekantrican Apr 13 '17 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.