Just modify Sandy's formula slightly:

=SUMPRODUCT(($E$14:$E$25="Pending Cost")*($F$14:$F$25="X"))

This assumes your status is listed in E14:E25 and New Submission is in
F14:F25 (taken from your original example), so adjust the references
to suit your data.

This will give you the count you require - don't be misled by the
function name "sumproduct".

Hope this helps.

Pete

On Jun 24, 11:26*pm, Annie wrote:
Sandy.. thanks for responding.. but I'm not using any numbers-- only text.. *
below is an example:
Status * * * * * * * * * * * * * New Submission * * * * * * * * * * *Comments
Pending Bus Case Review X * * * * * * *Received revised forecast
Pending Cost * * * * * *
Pending Cost * * * * * * * * * *X * * *
Pending Cost * * * * * * * * * *X * * *

I'm looking for a formula to count the total number of New Submissions (X)
for each individual Status

--
Thanks, Annie



"Annie" wrote:
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- Hide quoted text -

- Show quoted text -