How to look up a =COUNTA and =SUM formula from another sheet?

[Item Manager]

I'm trying to build a report that will look up the counta and total sum
formula's from one worksheet to another. I would like for this report to
consolidate all total cost from 54 sheets in the same workbook. Any
suggestions?

 

[Bob Phillips]

You can easily sum across sheets

=SUM('First sheet:Last sheet'!A1:A10)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Item Manager]

Bob,
Thanks for replying, but there's another issue I didn't mention. The
reports I'm recieving is never the same selected cells. One week I may have
5 submissions then the next, 30 submissions. This is why I'm asking for a way
to look up only the counta and sum formula from another sheet. See example:

Column M Column N Column 0 Column P Coulmn Q
AZ Y Y Y
AZ Y
AZ Y Y
Total is: 3 2 1
Total 6

Because each row number never stays the same is why I'm looking to only get
the counta and sum figure, which will automatically populate on another
sheet, no matter how many rows I get per week.

The final report should read:

Column A Column B Column C Column D Coulmn E
AZ 3 2 1
6
CA 4 2 2
8

Thanks a lot if you can help me solve this.

 

[Bob Phillips]

Not sure I understand. Are you saying you want to do a conditional count for
each sheet, or that the total will be in a fixed place on each sheet?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Item Manager]

A conditional count for each sheet.

Not sure I understand. Are you saying you want to do a conditional count for
each sheet, or that the total will be in a fixed place on each sheet?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)