Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count and Sum multiple values for a single entry
I am trying to reconcile some worksheets that tracks each time a truck took a
trip and how many gallons it hauled. Let's say on one spreadsheet, Truck 524 took 3 trips in one week. On a separate sheet, column A will say 524, Column be will be number of trips taken, Column C will be total number of gallons hauled. In longhand, it would look like this: TRUCK TRIPS GALLONS 524 4000 524 5000 524 6000 But in shorthand, I want it to look like this: TRUCK TRIPS GALLONS 524 3 15000 Any suggestions? I've tried a few formulas from Microsoft's website, but I'm getting value errors, even with their examples. Thanks for any help. Arlen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count and Sum multiple values for a single entry
B2: = COUNTIF(Sheet1!A:A,524)
C2: =SUMIF(Sheet1!A:A,524,C:C) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Arlen" wrote in message ... I am trying to reconcile some worksheets that tracks each time a truck took a trip and how many gallons it hauled. Let's say on one spreadsheet, Truck 524 took 3 trips in one week. On a separate sheet, column A will say 524, Column be will be number of trips taken, Column C will be total number of gallons hauled. In longhand, it would look like this: TRUCK TRIPS GALLONS 524 4000 524 5000 524 6000 But in shorthand, I want it to look like this: TRUCK TRIPS GALLONS 524 3 15000 Any suggestions? I've tried a few formulas from Microsoft's website, but I'm getting value errors, even with their examples. Thanks for any help. Arlen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count and Sum multiple values for a single entry
PERFECT!!! Thank you.
"Bob Phillips" wrote: B2: = COUNTIF(Sheet1!A:A,524) C2: =SUMIF(Sheet1!A:A,524,C:C) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Arlen" wrote in message ... I am trying to reconcile some worksheets that tracks each time a truck took a trip and how many gallons it hauled. Let's say on one spreadsheet, Truck 524 took 3 trips in one week. On a separate sheet, column A will say 524, Column be will be number of trips taken, Column C will be total number of gallons hauled. In longhand, it would look like this: TRUCK TRIPS GALLONS 524 4000 524 5000 524 6000 But in shorthand, I want it to look like this: TRUCK TRIPS GALLONS 524 3 15000 Any suggestions? I've tried a few formulas from Microsoft's website, but I'm getting value errors, even with their examples. Thanks for any help. Arlen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
single-cell multiple entry with pull-down list? | Excel Discussion (Misc queries) | |||
get a single count after looking up a set of values | Excel Worksheet Functions | |||
create a list of single values from multiple values | Excel Worksheet Functions | |||
Search multiple values to return single values | Excel Worksheet Functions | |||
How to count a range of values in a single cell? | Excel Worksheet Functions |