So I have a school project that is due next week so I am in desperate need of help, I hope to get this assignment done ASAP but I am very very bad at tech so be patient with me.
Basically what I need to do is to add the sum of an item from 3 separate excel spreadsheets and fill up a google form, however, I have no clue how. I will be attaching what I mean.
So from the images, you can see that there are 5 items that are the same on each sheet, what I need help to do is to add the quantity of each item individually, for example, 2 milk(From sheet 1) +8 milk(From sheet 2) + 0 milk(From sheet 3) together to get 10 milk. What activities and functions must I use in order to allow this to work?