I am trying to build a summary report from 12 individual worksheets.
Row 1 = revenue item
Column B-L = month
I would like to sum the values for the matched row across all 12 sheets.
I am trying to build a summary report from 12 individual worksheets.
Row 1 = revenue item
Column B-L = month
I would like to sum the values for the matched row across all 12 sheets.
Drag across.Please Login or Register to view this content.
Pete
That works if I dont have to search for the value in column A.
I have to sum the values in each month for the respective row label for the month
Might try:
(Could bog things down if there's lots of data to evaluate)Please Login or Register to view this content.
If that doesn't do it, a sanitized sample file for the forum members to look at would help.
Pete
I am sorry if I am being unclear. Let me try again.
I need to match each sheet row value to the the summary sheet row value adn sum, the corresponding matched month.
For example, I want to sum the values for all rows matching the value "410100 Rent - Seasonal RV" in row 8 in column D "Feb 21" for all the sheets from Bamboo to Sundowner.
Does this help explain int better?
Thanks ara.darakjian.
A sample file would eliminate all ambiguity.
Thanks.
I attached one. I will attached again.
Did this file help?
There's no file.
Let me try again.
my apologies
Not the best way, IMO but. . .
Try this in SUM C2. Copy down and over.
Total in Col. N.Please Login or Register to view this content.
Add sheet references as necessary.
Pete
Thank you for the reply. Is there a way to simplify the formula so that I can use it with as many as 20 worksheet?
You'll need a list of sheet names.
In the interest of not reinventing electricity. . .(Please remove if not allowed. . .)
This thread will probably provide further help: https://www.automateexcel.com/formul...ltiple-sheets/
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks