As a new user of MrExcel.com, I have found posts here quite helpful. Now I'm asking for your assistance.
Using previous Mr. Excel posts I was able to create the following array formula, which works great, as long as I choose one of the criteria choices (i.e. control = Profit or control = Non-Profit). However, I also need to be able to choose all companies regardless of control (i.e., control = either Profit or Non-Profit).
I need to be able do this with at least three of the criteria (control, bedrange, peergrp).
I would greatly appreciate any guidance offered.
{=SUM(IF(type=F$11,IF(bedrange=F$12,IF(coun=F$13,IF(control=F$14,IF(peergrp=F$15,IF(HOSP_BASE=F$16,SUMMARY!$Q$2:$Q$1309/F$18)))))))}
Using previous Mr. Excel posts I was able to create the following array formula, which works great, as long as I choose one of the criteria choices (i.e. control = Profit or control = Non-Profit). However, I also need to be able to choose all companies regardless of control (i.e., control = either Profit or Non-Profit).
I need to be able do this with at least three of the criteria (control, bedrange, peergrp).
I would greatly appreciate any guidance offered.
{=SUM(IF(type=F$11,IF(bedrange=F$12,IF(coun=F$13,IF(control=F$14,IF(peergrp=F$15,IF(HOSP_BASE=F$16,SUMMARY!$Q$2:$Q$1309/F$18)))))))}