Count unique entries in data range
 

Ok, retardation / stupidity have taken over the latter part my work day
here....I had a forumla working earlier and cannot seem to repeat it as I
didn't save my work....please help:

=SUM(IF((G3:G1000="Yes")+(G3:G1000="part")+(E3:E10 00<301)*(E3:E100024),1,0))

I am trying to select a set of ranges that are either "Yes" or "part" and
select another set of ranges that are between 25 and 300....I thought I had
another if in there somewhere but at this point in the afternoon my feable
brain is not capable of producing an answer....please help.

Count unique entries in data range
 

=SUMPRODUCT((G3:G1000={"Yes","Part"})*(E3:E1000=2 5)*(E3:E1000<=300))


"kcsims" wrote:

Ok, retardation / stupidity have taken over the latter part my work day
here....I had a forumla working earlier and cannot seem to repeat it as I
didn't save my work....please help:

=SUM(IF((G3:G1000="Yes")+(G3:G1000="part")+(E3:E10 00<301)*(E3:E100024),1,0))

I am trying to select a set of ranges that are either "Yes" or "part" and
select another set of ranges that are between 25 and 300....I thought I had
another if in there somewhere but at this point in the afternoon my feable
brain is not capable of producing an answer....please help.

Count unique entries in data range
 

think you want one less IF

=SUM(((G3:G1000="Yes")+(G3:G1000="part"))*(E3:E100 0<301)*(E3:E100024))

as an array formula, or

=SUMPRODUCT(--((G3:G1000="Yes")+(G3:G1000="part")),--(E3:E1000<301),--(E3:E100024))

not an array formula

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"kcsims" wrote in message
...
Ok, retardation / stupidity have taken over the latter part my work day
here....I had a forumla working earlier and cannot seem to repeat it as I
didn't save my work....please help:

=SUM(IF((G3:G1000="Yes")+(G3:G1000="part")+(E3:E10 00<301)*(E3:E100024),1,0))

I am trying to select a set of ranges that are either "Yes" or "part" and
select another set of ranges that are between 25 and 300....I thought I
had
another if in there somewhere but at this point in the afternoon my feable
brain is not capable of producing an answer....please help.