Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple SUMIF
I have a table as follows.
Date Customer Invoice Route Sales I have a formula at the end of the data column, SUMIF(B2:B1500=B2)*(A2:A1500=A2). This formula tells me if there are more than one time the Customer is repeated in a single date. Now I want to include in the same formula another condition that if in a single day, if the same customer is repeated but refer to a different route than others, count as "1". I am trying to determine the number of stops per customer. If the same customer has multiple Invoices on a single date, it is considered as one stop unless it was delivered by another Route driver. Any help is very much appreciated. K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF across multiple worksheets | Excel Worksheet Functions | |||
SUMIF across multiple worksheets | Excel Discussion (Misc queries) | |||
Countif & Sumif with Multiple criteria | Excel Worksheet Functions | |||
How to SUMIF multiple ranges? | Excel Discussion (Misc queries) | |||
Is it possible to specify multiple condition with SUMIF? | Excel Worksheet Functions |