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

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?

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

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" wrote in message
...
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?

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

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" wrote:

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" wrote in message
...
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?

How to look up a =COUNTA and =SUM formula from another 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)

"Item Manager" wrote in message
...
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" wrote:

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" wrote in message
...
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?

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

A conditional count for each sheet.

"Bob Phillips" wrote:

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" wrote in message
...
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" wrote:

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" wrote in message
...
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?