| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting and sumproduct formulas
I am attempting to count non-blank cells in one column that have to mee criteria from another column. I have played with the sumproduc function but to no avail....can someone assist? Example following: Column A represents the Month and Year and Column B represents Cost incurred. I want to count the number of times a Cost was incurre during the specific Month/Year. When a cost is not incurred, the cel remains blank. Column A Column B 01/2004 01/2004 $25.00 01/2004 02/2004 $15.00 02/2004 $20.00 02/2004 If the formula works correctly, my results would show 01/2004 1 02/2004 2 Please let me know if you have any ideas! :) Thanks............. -- samiam ----------------------------------------------------------------------- samiam1's Profile: http://www.excelforum.com/member.php...fo&userid=2874 View this thread: http://www.excelforum.com/showthread.php?threadid=48433 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| counting multiple criteria using SUMPRODUCT and getting #VALUE err | Excel Discussion (Misc queries) | |||
| counting dates using SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Adding a counting function within SumProduct | Excel Worksheet Functions | |||
| Counting non blanks with SUMPRODUCT? | Excel Discussion (Misc queries) | |||
Threaded Mode
