| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum values greater than x and less than y in a column
This is relatively simple and I can't figure it out. I have two cells (B1
and C1). B1 contains the low value and C1 contains the high value. I have data in column A and I want to sum all the values in the column that are between the two values in B1 and C1? Does this make sense? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum values greater than x and less than y in a column
=SUMIF(A:A,""&B1)-SUMIF(A:A,""&C1)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rookie_User" wrote in message ... This is relatively simple and I can't figure it out. I have two cells (B1 and C1). B1 contains the low value and C1 contains the high value. I have data in column A and I want to sum all the values in the column that are between the two values in B1 and C1? Does this make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I search an array for values in a column greater than zero | Excel Worksheet Functions | |||
| Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
| Formula to find greater of two values??? | Excel Discussion (Misc queries) | |||
| Need to print table values greater than a certain value | Excel Discussion (Misc queries) | |||
| How can I count values greater than and less than certain values? | Excel Worksheet Functions | |||
Linear Mode
