•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sum all values of a specific type
I have my flying log as a single table of aircraft types (A1:A999) and number of hours flown (B1:B999). I used the UNIQUE(A1:A999) function to get a list of each aircraft type on the next page (C1:C25). How can I sum the hours of each aircraft type to go in D1:D25?
| GA8 | 0.9 |
|---|---|
| BO105 | 1 |
| C182 | 0.8 |
| EC145 | 1 |
| UH1N | 1 |
| BO105 | 1 |
| C172 | 0.9 |
| C90A | 1 |
| EC145 | 1 |
| EC145 | 1 |
| OH58 | 1.4 |
| UH1N | 1 |
| BO105 | 1 |
| C172 | 1 |
| UH1N | 0.8 |
| UH1N | 0.8 |
| OH58 | 1 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#hours flown
#sum
#BO105
#EC145
#UH1N
#hours
#aircraft types
#UNIQUE function
#C172
#OH58
#flying log
#C182
#C90A
#Excel
#D1:D25
#A1:A999