| 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. |
| 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 | |||
Threaded Mode
