•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