On Jan 22, 3:25*am, Values sum in Multuiple Worksheet/cell <Values sum
in Multuiple wrote:
I have multiple worksheet with different location of values(cell number in
different row) to sum up, but with one reference. Example;

I need to sum up the number of apples in one workbook:

1. worksheet (1) where it says 25 apples in row 100, column AJ
2. worksheet (2) where it says 100 apples in row 200, column AJ
3. worksheet (3) where it says 200 apples in row 300, column AJ

In one worksheet, there is a table of many fruits Banana, Pineapple,
strawberry, etc. that has also values at different rows. The table is
generated by our computer where it comes randomly as entered by the supplier.
Displacement is due to no entry on days where there is no delivery.

The only reference for apple to distinguish from other fruits is the name
"Apple" which is also positioned in a different row but on the table of
apples in the worksheet.

From the above example, it should give me a total of 325 apples for one
workbook.

Please help... Thanks - VL

Not quite sure about the requirements, but it sounds like a job for
SUMIF.

Presumably, there's a column indicating the fruit for each row.
Suppose it's column A.

Then something like this might be useful:
=SUMIF(Sheet1!A:A,"Apple",Sheet1!AJ:AJ)+
SUMIF(Sheet2!A:A,"Apple",Sheet2!AJ:AJ)+
SUMIF(Sheet3!A:A,"Apple",Sheet3!AJ:AJ)