| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count the # of entries when sum matches the target
Dear all,
How to count the number of integers when sum of those, calculated from left to right, meets a predefined target E.g: Range: 50, 100, 200, 100, 150, 300 Target: 450 Function should return 4 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| count data but avoid double entries | Excel Worksheet Functions | |||
Threaded Mode
