ExcelBanter - If statements from multiple sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If statements from multiple sheets (https://www.excelbanter.com/excel-discussion-misc-queries/446946-if-statements-multiple-sheets.html)

If statements from multiple sheets

Hey there, I'm hoping somewhere will be able to help me here.

I am trying to conditionally gather information from multiple sheets. On each sheet the cell "B5" has the release # that I need to sort through. I was hoping to use statement like =IF(B5=1,H38(gets added into a total))

The cell H38 on every page will need to be autosumed, into categories, which the B5 cell states.

I know that I'm not explaining this well, I just a little lost on this one.

Thank you,

Quote:

Originally Posted by CurtainwallEstimator (Post 1604940)

Hi,

How many sheets would you be in the workbook?

Would adding a sheet that holds a calculation table (it can be hidden) be a possibility? It would make this a relatively simple task.

Happy to assist but perhaps an example worksheet would be useful. Either post it here or email it to me on pubnut @ gmail . com (without spaces) and I'll have a look at it from there.

S.