Multiple formulas based on 1 answer.

[Kevin M]

Hi all, TIA, i'm working with an existing book and the
user would now like to be able to pull some tallies from
the sheets. Unfortunately, the sheet now looks after more
than one area. I currently have the following on a
seperate sheet in the book:
#Assigned =COUNTA('Rig Managers'!G2:G500)

#Spare =COUNTA('Rig Managers"!G2:g500,"Spare")

#HD Experience adding new column for it

#Active =COUNTIF('Rig Managers'!$I:$I,"a")

#Down =COUNTIF('Rig Managers'!$I:$I,"d")

#Unavailable =COUNTIF('Rig Managers'!H2:H500,999)

#Spare Available =COUNTA(AND('Rig Managers'!
$G$2:$G$500="",'Rig Managers'!$H$2:$H$500=111))

I need to add something to all of the formulas to first
look for their respective locations: RD, SL, SH, CA... Is
an =IF(Target cell="RD"... the only way to do it?

Thanks for the help.

Kevin M