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

Please load and we can review your situation

User
03/10/2018 - 06:36

that's it

[Uploaded an Excel file]

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

Please stand by

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

Please stand by

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

if you can adjust just go ahead

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

[Uploaded an Excel file]

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

If not - repost, please

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

Please do it and sent through my mail please

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

i will be very glad

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