Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count invoices by day
I have a spreadsheet that I track invoices by day. How do I count the number
of invoices by each day of the month? Some of the invoices have multiple line items on them so I don't want to count those as individual invoices. I only want to count the invoices for a day and only count 1 of the multiple line item invoices. This way it won't count each line item as an invoice for that day. Column A has the invoice date and column B has the invoice number. I want to put this on a different worksheet and summarize it by day. I have a list of days on my summary worksheet in column A. So basically I'd want to match the date on my summary worksheet with the invoice date. Any help would be greatly appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to count spinoffs | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |