Can anyone assist me. I am using this formula:
=COUNTA(IF($E$14:$E$25,"Pending Cost")*($F$14:$F$25=X), $G$14:$G$25) to count
a certain criteria based on if there is an "X" in the cell beside it. It has
only worked for one of my four criteria's, eventhough I've changed the
criteria (pending cost) to another, pending business case review. Can anyone
help me, please? I am using Excel 2003
--
Thanks, Annie