| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of times data matches
Colin
If you want to do it with a single array formula, try: =SUM(--(A1:A40<B1:B40)) entered as an array (shift-ctrl-enter) Good luck. Ken Norfolk, Va On Sep 11, 12:48 pm, Colin wrote: I have two columns of numerical data in range a1:b40. The cells hold values from 1 to 9. I want to count the number of times 'column a' data is less than or equal to 'column b' data. How do I do this? -- Thank you, Colin. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of times certain Text Values appear | Excel Discussion (Misc queries) | |||
| Create Chart by Counting Number of Times Data is Used | Excel Discussion (Misc queries) | |||
| counting the number of times something is bought during a month | Excel Worksheet Functions | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Counting the number of times someone called in sick | Excel Discussion (Misc queries) | |||
Threaded Mode
