I use " =SUMIF(range-containing-aircraft-types,cell-containing-aircraft-name, range-containing-flying-hours) ".
My Excel logbook handles that fine for 100ish types. My person preference is to split it over three sheets that contain:
(1) Classical logbook information
(2) Calculations
(3) 1 page presentational logbook summary that I can print out.
(1) I enter data on, (3) is all that useful stuff like total experience, hours on type, hours in last 28/90/365 days, instructional hours, expiry dates....
(2) is just necessary but best kept away from the other two.
G