I cannot figure this out for the life of me. I have three columns that need to be looked at. I attached the spreadsheet that I am trying to figure out. Notes are in speadsheet. Thanks in advance for all the help.

try this

=SUMPRODUCT(--('FIRE ALARM DEVICES'!$A$8:$A$433=$A19),--(RIGHT('FIRE ALARM DEVICES'!$B$8:$B$433,2)=TEXT(C$18,"00")),--(LEFT('FIRE ALARM DEVICES'!$D$8:$D$433,2)=TEXT($B19,"00")))

copy formula over and down

Thank you for the help and the formula. I do have oen question though:

Becuase I am still new at figuring the formulas and how to manipulate them, Is this formula one formula or is it in sections?

Thanks

it is one formula

Thanks for all of your help.