Thread
:
Nesting Formulas
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Nesting Formulas
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann