**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.*