| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to sum columns based on # in Cell A1
I have columns 5-16 (E:P) filled with monthly data.
Column 5 (E) contains May, column 6 (F) June, etc. I n Cell A1 I have the current month (7 for July, 8 for Aug, etc.). Cell A1 has the formula =now() in it and is formatted as "m" so it only shows 7 for July, which corresponds with column 7 (G). I want to sum cells E5 through ?5 based on the number in cell A1. For July the sum would be E5:G5, for August it would be E5:H5, etc.) What fomula would I use to create the sum based on the data in cell A1? TIA! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I have a formula result based on multiple criteria/columns | New Users to Excel | |||
| Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
| Automatically resize columns based on new formula result | Excel Discussion (Misc queries) | |||
| formula to count based on data in two different cells/columns | Excel Discussion (Misc queries) | |||
| How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
Threaded Mode
