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

If I understand you correctly try:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Annie" wrote in message
...
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

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

In that case do you not simply want:

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

To count the number of entries of "Pending Cost" with an X in the next cell.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Annie" wrote in message
...
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

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 -

Sandy and Pete--- Thank you so much!!! It Works!!! YAY!!!!
--
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

Well, someone seems happy !! Thanks for feeding back - always
appreciated.

Pete

On Jun 25, 12:22*am, Annie wrote:
Sandy and Pete--- Thank you so much!!! It Works!!! YAY!!!!
--
*Annie