# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Please i want items listed within the file name m_consumable under "Quantities" should reflect in A_consumables (only the total quantities) under the respective categories Column M that is opening stock of each items "laboratory, Supplier, Production
Solved by D. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 03/10/2018 - 06:34
yes
User 03/10/2018 - 06:34
Please am running out of time
User 03/10/2018 - 06:34
can you help me out?
Excelchat Expert 03/10/2018 - 06:35
Welcome to Excelchat,
User 03/10/2018 - 06:35
Thank you
Excelchat Expert 03/10/2018 - 06:35
Do you have a sheet to upload?
User 03/10/2018 - 06:35
yes
Excelchat Expert 03/10/2018 - 06:36
User 03/10/2018 - 06:36
that's it
Excelchat Expert 03/10/2018 - 06:37
OK , file open
User 03/10/2018 - 06:37
Please i want items listed within the file name m_consumable under "Quantities" should reflect in A_consumables (only the total quantities) under the respective categories Column M that is opening stock of each items "laboratory, Supplier, Production
Excelchat Expert 03/10/2018 - 06:39
m_consumable "Quantities need to be totalled and placed in the A_consumables sheet?
User 03/10/2018 - 06:39
yes
Excelchat Expert 03/10/2018 - 06:39
What column row in the A_consumables sheet?
User 03/10/2018 - 06:40
M
User 03/10/2018 - 06:40
opening stock
Excelchat Expert 03/10/2018 - 06:40
Opening stock is column N -correct?
User 03/10/2018 - 06:41
yes N
User 03/10/2018 - 06:41
sorry
Excelchat Expert 03/10/2018 - 06:41
There is a formula there already-not working?
User 03/10/2018 - 06:41
yes
User 03/10/2018 - 06:42
i tried doing it but i couldn't
Excelchat Expert 03/10/2018 - 06:44
Is the SUM intended to use column L and M?
Excelchat Expert 03/10/2018 - 06:44
N6 should sum 25KG CARTON & Laboratory?
User 03/10/2018 - 06:45
yes
User 03/10/2018 - 06:45
in that order
Excelchat Expert 03/10/2018 - 06:46
And column L and M correspond to column F and D in the M sheet?
User 03/10/2018 - 06:47
yes
Excelchat Expert 03/10/2018 - 06:47
Ok, let me work on this in EXCEL and get it back to you
Excelchat Expert 03/10/2018 - 06:47
User 03/10/2018 - 06:49
okay... also i want the Total number of Quantities that will come in (in M_consumables should reflect in A_consumables under the Warehouse section and also that will go out should also reflect under out)
Excelchat Expert 03/10/2018 - 06:50
Ok, lets see where we are after the first question
User 03/10/2018 - 06:50
okay
Excelchat Expert 03/10/2018 - 06:50
this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 03/10/2018 - 06:51
okay
Excelchat Expert 03/10/2018 - 06:51
Excelchat Expert 03/10/2018 - 06:55
Formula is in the first section , but not picking up data?
Excelchat Expert 03/10/2018 - 06:55
25KG CARTON does not match Carton 25 KG (FON)?
Excelchat Expert 03/10/2018 - 06:56
is the first clue
Excelchat Expert 03/10/2018 - 06:56
Is that a match-something that needs to adjust to drop the (FON)?
User 03/10/2018 - 06:57
User 03/10/2018 - 06:58
but i will be happy if you can take both
User 03/10/2018 - 06:58
both the "25 KG CROWN AND FON"
Excelchat Expert 03/10/2018 - 07:00
I can use these rows M 123
Excelchat Expert 03/10/2018 - 07:00
Carton 15 KG (CROWN) Carton 25 KG (CROWN) Carton 25 KG (FON)
User 03/10/2018 - 07:00
Yes
User 03/10/2018 - 07:00
thats how i have categorized it
User 03/10/2018 - 07:02
but i want the total of all 25KG should reflect under M
User 03/10/2018 - 07:02
Sorry N
Excelchat Expert 03/10/2018 - 07:02
Can you verify this first section is correct?
Excelchat Expert 03/10/2018 - 07:02
OPENING 25KG CARTON Laboratory 42 Supplier 289165 Production 10
User 03/10/2018 - 07:03
Please with respect of the date
Excelchat Expert 03/10/2018 - 07:03
Date?
User 03/10/2018 - 07:03
yes
Excelchat Expert 03/10/2018 - 07:04
Where does data appear on the A sheet?
User 03/10/2018 - 07:04
scroll to the far left
Excelchat Expert 03/10/2018 - 07:05
FROM: 01/10/18 TO : 01/10/18 ?
User 03/10/2018 - 07:05
yes
Excelchat Expert 03/10/2018 - 07:05
A single day?
User 03/10/2018 - 07:05
Good
User 03/10/2018 - 07:05
yes
Excelchat Expert 03/10/2018 - 07:05
Ok
Excelchat Expert 03/10/2018 - 07:11
Date is not retuning, still working
User 03/10/2018 - 07:11
okay
Excelchat Expert 03/10/2018 - 07:13
It is column D in the M sheet -just to verifyFrom Supplier
Excelchat Expert 03/10/2018 - 07:14
I think it is working the first section is all ZEROS
Excelchat Expert 03/10/2018 - 07:14
25KG CARTON Laboratory 0 Supplier 0 Production 0
User 03/10/2018 - 07:15
in relation with the date
Excelchat Expert 03/10/2018 - 07:15
10/1/2018 this date
Excelchat Expert 03/10/2018 - 07:15
listed as 1/10/2018 EURO format
User 03/10/2018 - 07:16
i mean if the date changes............ the quantities should also change
Excelchat Expert 03/10/2018 - 07:16
yes
User 03/10/2018 - 07:16
okay
Excelchat Expert 03/10/2018 - 07:21
Ok, I have the first section in and tested with date 31/10/17
Excelchat Expert 03/10/2018 - 07:22
Looks ok
User 03/10/2018 - 07:22
okay
Excelchat Expert 03/10/2018 - 07:23
Next section; can I use this: 25KG BLANK CROWN or do we need helper rows like in M1,2,3?
Excelchat Expert 03/10/2018 - 07:23
Are there variations of 25KG BLANK CROWN
User 03/10/2018 - 07:24
yes
User 03/10/2018 - 07:25
only the Totals of 25KG BLANK CROWN needs to reflect under the that section
Excelchat Expert 03/10/2018 - 07:25
Ok, just 25KG BLANK CROWN
User 03/10/2018 - 07:25
yes
Excelchat Expert 03/10/2018 - 07:29
There are no products listed as 25KG BLANK CROWN?
User 03/10/2018 - 07:29
ye
Excelchat Expert 03/10/2018 - 07:29
There is Carton 25 KG-Blank (CROWN)
Excelchat Expert 03/10/2018 - 07:30
Should I change L9?
Excelchat Expert 03/10/2018 - 07:30
I changed it , it works
User 03/10/2018 - 07:30
yeah change it
User 03/10/2018 - 07:31
oops my time is up
Excelchat Expert 03/10/2018 - 07:31
In the time remaining , I need to get you the sheet
User 03/10/2018 - 07:31
okay
User 03/10/2018 - 07:31
please have you done the other section
Excelchat Expert 03/10/2018 - 07:31
User 03/10/2018 - 07:31
the in and out
Excelchat Expert 03/10/2018 - 07:32
did only 2 sections, but I think you can follow these 2 examples and complete
Excelchat Expert 03/10/2018 - 07:32
User 03/10/2018 - 07:32
how can i re post
Excelchat Expert 03/10/2018 - 07:33
the same way you posted this request.
User 03/10/2018 - 07:33
Excelchat Expert 03/10/2018 - 07:33
Ask for same Expert, and I will try to pick up
Excelchat Expert 03/10/2018 - 07:33
Ok, I can send via , site support, they have your email
User 03/10/2018 - 07:33
okay
User 03/10/2018 - 07:33
Excelchat Expert 03/10/2018 - 07:33
Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day.
User 03/10/2018 - 07:34
Thanks

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.