Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating the sum if two criteria are met?
Hello folks,
I have a spreadsheet that has (in sheet 2) column H with a number of days in stock (1-60+) and the profit for that vehicle in column W. I want to add all the profit for the vehicles that are in stock between 31 and 45 days for example. i.e. if column H is between 31 and 45 what is the corresponding profit in column W. This then would enable me to calculate the total/average profit for any age band. The bands will be 1-30, 31-45, 46-60 and 61+. Thank you in anticipation. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating the sum if two criteria are met?
=SUMIF(H:H,"30",W:W)-SUMIF(H:H,"45",W:W)
etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bruce Hancock" wrote in message ... Hello folks, I have a spreadsheet that has (in sheet 2) column H with a number of days in stock (1-60+) and the profit for that vehicle in column W. I want to add all the profit for the vehicles that are in stock between 31 and 45 days for example. i.e. if column H is between 31 and 45 what is the corresponding profit in column W. This then would enable me to calculate the total/average profit for any age band. The bands will be 1-30, 31-45, 46-60 and 61+. Thank you in anticipation. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating the sum if two criteria are met?
Spot on thank you Bob!
"Bob Phillips" wrote: =SUMIF(H:H,"30",W:W)-SUMIF(H:H,"45",W:W) etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bruce Hancock" wrote in message ... Hello folks, I have a spreadsheet that has (in sheet 2) column H with a number of days in stock (1-60+) and the profit for that vehicle in column W. I want to add all the profit for the vehicles that are in stock between 31 and 45 days for example. i.e. if column H is between 31 and 45 what is the corresponding profit in column W. This then would enable me to calculate the total/average profit for any age band. The bands will be 1-30, 31-45, 46-60 and 61+. Thank you in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Mode for multiple arrays based on criteria in another | Excel Worksheet Functions | |||
Calculating values from multiplesheets with multiple criteria | Excel Worksheet Functions | |||
Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions | |||
Calculating Sum with Multiple Field Criteria | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |