Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to use sumif, but don't have a set column for the sum range.
For example: A B C D E 1 Apr Mar Feb Jan 2 3 apples 12 14 15 14 4 bananas 26 32 30 35 5 apples 7 7 4 5 6 grapes 19 22 22 20 7 oranges 6 5 6 7 I can use sumif(a:a,"apples",d:d) to sum February, but next month when I add May data February shifts out to column E. How do I create a reference to the proper column? I've been working with offset, indirect, match, etc but can't seem to come up with the right combination to make it work. Thanks for all of your thoughts! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Maintain Relative Reference After Inserting a Column | Excel Worksheet Functions | |||
Relative reference | Excel Worksheet Functions | |||
Relative Reference | Excel Discussion (Misc queries) |