Sum, several different sheets in the same workbook

J

Joe

Hello

I have tried below, and it works superb - but not all of the data i want to
sumarise is on the same line on each sheet.

so i want to do something like this
=SUMIF(First:Last!A1:A202,A26,First:Last!B1:B202), but it is returning a
#value.

What am i missing?

help, and thanks

-----------------------------------------------------------------------------------------------------------------


Suppose your worksheets aren't in any kind of sequential order. Or you have
50 worksheets, and you only want to sum 30 of them, but you're constantly
adding worksheets, so the beginning and end worksheet names may change?

In this case, place a blank worksheet to the left of the first worksheet you
want to include in the formula. Call that worksheet "First". Insert another
blank worksheet after the last worksheet you want to include in the formula.
Call that worksheet "Last". You can even hide these worksheets!

Then, your formula will be:

=SUM(First:Last!A2)
 
B

bj

I can't make my sheet name include the ":"
try
=SUMIF(FirstLast!A1:A202,A26,FirstLast!B1:B202)
If this doesn't work, what is in B26?
 
J

Joe

First:Last! Refers to two seperate sheets, the first one and the last one of
the 20 that i want to pick data up from.
 
B

Bob Phillips

If the data is not the same cell on each worksheet, how do you know where it
is, what is the rule?
 
B

bj

sorry, sumif does not work for 3d equations
Workarounds include
setting a common point for a sumif equation on each sheet and using a 3d sum
function on that cell
Writing a macro to do the sumif
setting a series of sumifs on one sheet and summing the series.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top