|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 8th, 2009, 08:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing text and then adding numbers if the text matches
Hello folks, I'm a very basic excel user. I'm trying to create a spread
sheet for adding flight times. Here's how the table looks: Aircraft Type Total Time BH206 4 BE90 5 BH206 2.5 BE90 3 I need to add the the times only for the aircraft of the same type. (additionally the aircraft type is user function which I've already been able to make work). Once the numbers are added that answer gets added to another cell of a previous total for the same aircraft to create a total time. Any help??? Thanks 
|
|
#2
April 8th, 2009, 08:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing text and then adding numbers if the text matches
Try
=SUMIF(A1:A14,"BE90",B1:B14) Mike "rotor11" wrote: Hello folks, I'm a very basic excel user. I'm trying to create a spread sheet for adding flight times. Here's how the table looks: Aircraft Type Total Time BH206 4 BE90 5 BH206 2.5 BE90 3 I need to add the the times only for the aircraft of the same type. (additionally the aircraft type is user function which I've already been able to make work). Once the numbers are added that answer gets added to another cell of a previous total for the same aircraft to create a total time. Any help??? Thanks
|
|
#3
April 8th, 2009, 08:38 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing text and then adding numbers if the text matches
=SUMPRODUCT((A1:A10="BE90")*(B1:B10))
this will add up the BE90 items Adapt for the others. -- Gary''s Student - gsnu200844 "rotor11" wrote: Hello folks, I'm a very basic excel user. I'm trying to create a spread sheet for adding flight times. Here's how the table looks: Aircraft Type Total Time BH206 4 BE90 5 BH206 2.5 BE90 3 I need to add the the times only for the aircraft of the same type. (additionally the aircraft type is user function which I've already been able to make work). Once the numbers are added that answer gets added to another cell of a previous total for the same aircraft to create a total time. Any help??? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
