Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to pop at the upper left corner of a spreadsheet. If I enter the month "January," I want the column number sum of January =SUM(AB11:AB75) from another section on the same excel page to pop right below the "January" cell, and not display the formula expression, but see the $100.
Solved by T. Q. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
03/04/2018 - 10:44
I need a formula to pop at the upper left corner of a spreadsheet. If I enter the month "January" or "February," I want the column number sum of January =SUM(AB11:AB75) from another section on the same excel page to pop right below the same cell, and not display the formula expression, but see the $100.
Excelchat Expert
03/04/2018 - 10:44
Hello
User
03/04/2018 - 10:44
Hello
Excelchat Expert
03/04/2018 - 10:44
sorry about delay
User
03/04/2018 - 10:45
actually i made the problem clearer
User
03/04/2018 - 10:45
so i needed the extra time
Excelchat Expert
03/04/2018 - 10:45
Ok
User
03/04/2018 - 10:45
and to get familiar with this service and set up
User
03/04/2018 - 10:46
i don't know if you can see my spreadsheet, but i would like to pop in January, or any other month in the same spot in the top left corner
Excelchat Expert
03/04/2018 - 10:46
what is the range AB11:AB75
User
03/04/2018 - 10:46
it's jut a column. i jut need the total at the bottom
Excelchat Expert
03/04/2018 - 10:47
You need to total all the cells under the January or February
Excelchat Expert
03/04/2018 - 10:47
Right
Excelchat Expert
03/04/2018 - 10:47
?
User
03/04/2018 - 10:47
if you can see my worksheet, i did that
User
03/04/2018 - 10:47
150
Excelchat Expert
03/04/2018 - 10:47
Ok
Excelchat Expert
03/04/2018 - 10:47
I see
Excelchat Expert
03/04/2018 - 10:48
always the last cell is the sum
User
03/04/2018 - 10:48
can you see my work sheet?
Excelchat Expert
03/04/2018 - 10:48
Yes
Excelchat Expert
03/04/2018 - 10:48
I see
User
03/04/2018 - 10:49
i want to be able to type the month at the top left and the sum appears right below it
Excelchat Expert
03/04/2018 - 10:49
You can use the Hlookup if the columns always the same length
User
03/04/2018 - 10:49
yes same length
Excelchat Expert
03/04/2018 - 10:49
Ok
Excelchat Expert
03/04/2018 - 10:50
check the formula
User
03/04/2018 - 10:51
yes, please spread through December
User
03/04/2018 - 10:52
and i don't mind paying for this, so what would be the charge please
User
03/04/2018 - 10:54
wow
Excelchat Expert
03/04/2018 - 10:54
OK
User
03/04/2018 - 10:54
looks great. how much to pay for this?
Excelchat Expert
03/04/2018 - 10:55
Ok
User
03/04/2018 - 10:55
oh gorgeous!
Excelchat Expert
03/04/2018 - 10:55
Anything else about this
User
03/04/2018 - 10:55
no, i am thrilled to death!
Excelchat Expert
03/04/2018 - 10:55
Have a good day
User
03/04/2018 - 10:56
Thank you!!!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.