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.