Spreadsheet calculating sum of values as per date and specific text

by CodeMonkey   Last Updated July 17, 2018 02:03 AM

I have the following data in a Google Spreadsheet:

+------+------------+---------------+---------+---------+
| Date | Difficulty |               |Date     | Points  |
+------+------------+---------------+---------+---------+
| Jul15| Easy       | Easy (1pts)   |  Jul15  |4        |
| Jul15| Easy       | Medium (2pts) |  Jul16  |5        |
| Jul15| Medium     | Hard (3pts)   |         |         |
| Jul16| Hard       |               |         |         |
| Jul16| Medium     |               |         |         |
+------+------------+---------------+---------+---------+

I would like to add up all the points for a date in the column date/points where points for a date are next to each other. Points depend on difficulty and are in column 3.

I was able to get the dates in column 4 by using

=UNIQUE(A2:A800)

However, unable to get points 4, 5 etc in column 5. Can someone suggest how it can be done?

Tags : google-sheets


Related Questions



Copying values between google sheets

Updated July 26, 2018 21:03 PM