| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count in Excel
Hello Don,
Sorry, but no. SUMPRODUCT has already been offered too often for tasks which are too complex or which (as in this obvious case) require too much manual (and repeating!) effort. I would either recommend a pivot table or my UDF Sfreq: http://www.sulprobil.com/html/sfreq.html If there are more tasks to do I would suggest a proper database application. Regards, Bernd PS: It's about time to add SUMPRODUCT to my Excel Don'ts, I guess :-) http://www.sulprobil.com/html/excel_don_ts.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Hybrid Mode
