Sumifs acrossed multiple pages with a check each time

[Timberwolf]

Hi all

I have a workbook with about 50 worksheets. Each work sheet is for a separate vendor each vendor has expenses divided by month the vendors are one of 7 GL accounts. I have a summary page on sheet 1. What I want is to have a formula check each page and if it finds that the GL number in cell Q1 on each page matches a header on the summary page then it would add the number in B2 on each page to cell N3 on the first page.

if some one could tell me how to upload the file I can do that to make it easier to explain.

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[Timberwolf]

Ok thank you. I understand