M
M Imran Buhary
I have a sales database with several columns. In one column I have customer
name (Unique ID). I have sales details of all invoices listed and some are
been paid and some are pending for payment. I want to extract in another
worksheet a total of pending invoices for each customer. I need to do this
without PIVOT Tables.
I have listed the Unique customer names in the other worksheet and try to
use sumif formular. But i have the problem to give 2 conditions one is to
match the Customer ID and also to look for pending invoices only.
Can anyone help on this one please !
name (Unique ID). I have sales details of all invoices listed and some are
been paid and some are pending for payment. I want to extract in another
worksheet a total of pending invoices for each customer. I need to do this
without PIVOT Tables.
I have listed the Unique customer names in the other worksheet and try to
use sumif formular. But i have the problem to give 2 conditions one is to
match the Customer ID and also to look for pending invoices only.
Can anyone help on this one please !