Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating in a list
I have a spreadsheet where there are multiple columns with fixed cells at the top performing calculations based on average, min, standard deviation etc. for the values listed in the column below. I was wondering if there is a formula or way of making the fixed cells calculate on the the data I have listed instead of calculating the all of the values currently in the column. For example, in my "Days" column I will select "2" and all the values in the "Tree Growth" column will be listed beside them for day 2, but my fixed cells will still calculate all of the values in the "Tree Growth" column. Is there a way for me to create a formula so the fixed cells will calculate only the values listed in the "Tree Growth" column if I select day 2 or any day from my list? Or any other way to remedy this problem? Any help in this matter would be greatly appreciated. -- g0604002 ------------------------------------------------------------------------ g0604002's Profile: http://www.excelforum.com/member.php...o&userid=35550 View this thread: http://www.excelforum.com/showthread...hreadid=553136 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating in a list
Look at SUMIF (as a starter) and/or SUMPRODUCT.
"g0604002" wrote: I have a spreadsheet where there are multiple columns with fixed cells at the top performing calculations based on average, min, standard deviation etc. for the values listed in the column below. I was wondering if there is a formula or way of making the fixed cells calculate on the the data I have listed instead of calculating the all of the values currently in the column. For example, in my "Days" column I will select "2" and all the values in the "Tree Growth" column will be listed beside them for day 2, but my fixed cells will still calculate all of the values in the "Tree Growth" column. Is there a way for me to create a formula so the fixed cells will calculate only the values listed in the "Tree Growth" column if I select day 2 or any day from my list? Or any other way to remedy this problem? Any help in this matter would be greatly appreciated. -- g0604002 ------------------------------------------------------------------------ g0604002's Profile: http://www.excelforum.com/member.php...o&userid=35550 View this thread: http://www.excelforum.com/showthread...hreadid=553136 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
How to link data from one drop-down list to another | Excel Worksheet Functions | |||
data validation--multiple dependent list | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |