Home |
Search |
Today's Posts |
#1
|
|||
|
|||
This is A LOT harder than I thought it would be
I am trying todo something which I "thought" would be simple.
I have a column of number from 0 through 77. I have another column beside of it. The numbers are like this: 1 5 1.1 6 1.3 4 1.35 5 1.5 6 All the way to 77. I am trying to write a code in VBA that says, basically, if the value in this cell is between (for instance, 1 and 1.3 then sum the values from the corresponding column. The answer to the above would be 15. ELSE, if the values are between 1.35 and 1.5, then sum the values in the corresponding column (the answer being 11) and so on. I wanted to store the answer values in specified cells on the same worksheet. Can someone please help? Thanks. -- RSF |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
Things are getting a little harder! | New Users to Excel | |||
another thought on COUNTIF 2 VARIABLES ?? | Excel Worksheet Functions | |||
On second thought ... | New Users to Excel |