Microsoft Excel - Formula to determine number of units at each location and status of units

Can someone please help me with the formulas I have in cells F12, F13, G12 & G13 that are not working.

Thanks,

Hi Kathy,

Perhaps if you told us what the formulae were or attached the file we might be able to help.

Regards

Harry