In advance, thank you so much for the help!
Please take a look at the attached file. I am trying to enter formulas to pull from the 'Detail' Tab into the Risk Segmentation Tab - cell c3 was a poor effort of said attempt.
On the Risk Segmentation Tab Columns C - F should be a count of Column F - 'Facility Name' on the 'Detail' Tab
On the Risk Segmentation Tab J - M should be a SUM of Column H - '#Beds' on the 'Detail' Tab
On the Risk Segmentation Tab Q - T should be a SUM of Column J - 'Annual Revenue' on the 'Detail' Tab
I could do a pivot table, but perfer the formulas ]
Bookmarks