| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Entries | Excel Worksheet Functions | |||
| Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count of unique entries | Excel Discussion (Misc queries) | |||
| How to validate data entries to be unique within an array | Excel Worksheet Functions | |||
Hybrid Mode
