Lookup and sum values across multiple worksheets

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.

Please Login or Register  to view this content.

Drag across.

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:

Please Login or Register  to view this content.

(Could bog things down if there's lots of data to evaluate)

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.

Please Login or Register  to view this content.

Total in Col. N.

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