Hi all

How can I sumif over multiple tabs?? Without using sumif(a:a,sheet1!a1,c:c)+sumif(a:a,sheet2!a1,c:c)

Like sumif(sheet1:sheet2!a:a,a1,sheet1:sheet2!c:c) I do not want to use a macro. I have about 80 sheets.

Sheet1
Apples 93
Pears 49
Oranges 20
Bananas 35

Sheet2
Apples 100
Pears 13
Oranges 2
Bananas 350

Many thanks