On sheet one i have 3 colums,
colum one has the stock name,
colum three has the stock amount

these stack names and amounts however are duplicated throughout sheet one.
so
A B C
1 Apple red fruit 2
2 Banana fruit 5
3 Cheese gouda Dairy 6
4 Apple red fruit 8

etc…

now on sheet 2 i would like a total of all apple’s red quantity from sheet 1

can anyone help, i know its a easy formula, i just somehow forgot it

Assuming A has the stock name and C has the stock quantity.

You can also have the middle term of the function reference another cell instead of static “Apple”, so you can have a dynamic formula that copies down and can return the amounts of any stock name in the target cell.

You can replace the text in that formula with whatever cell the text is in as well. For example if you’ve labeled the table you want to populate with “Apple” in cell A1, then A1 can replace “Apple” in the formula. Just make sure to anchor it correctly otherwise copying the formula out or down will go kaflooey on you.