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,