| Home |
| Search |
| Today's Posts |
|
#1
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Text, Date and Numbers together in a formula | Excel Discussion (Misc queries) | |||
| Adding numbers to text! | Excel Worksheet Functions | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| adding cells with text and numbers | Excel Discussion (Misc queries) | |||
| Adding cells with numbers and text | Excel Worksheet Functions | |||
Linear Mode
