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 |
Multiple SUMIF
Pls use plain text
Without seeing your data, here is a formula you may adapt =sumproduct((a2:a22="Joe")*(b2:b22=1)*(c2:c22=<10 )) to count to sum col d that meets the criteria =sumproduct((a2:a22="Joe")*(b2:b22=1)*(c2:c22=<10 ),d2:d22) -- Don Guillett SalesAid Software "Krish" wrote in message ... 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 |
All times are GMT +1. The time now is 07:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com