Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a spreadsheet that lists all customer orders for the year - each order
is a row. I need to count the number of orders per customer per month. I'm having trouble figuring out what formula to use to count the number of rows in which the customer column (a range named "customer") = "xxx" and the month column (a range named "month") = 1 (for January). I've tried several combinations of things and keep getting errors. I've tried ROWS, COUNTIF, IF with COUNTIFs and/or ROWS, etc. to the point that I'm thoroughly confused. I'm sure this is probably simple but I just can't seem to see it at this point. Thanks for your help! -- JoAnn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How cell ranges are handled by worksheet functions/row column matc | Excel Worksheet Functions | |||
Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
how do I use variable column and rows using other cell reference . | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |