unpaid Invoices

Hi,

i have created a summary report in excel and i have now combined the data with sumif function, i have managed to display the dates and the cost of each customers total cost but what i could not do is to show what customer has paid and what customer has not paid

below is the table fields that i use
Company Total Cost Date Qty Paid

all i want to do now is in the summary show what the total cost is and if it is paid for it

hope i have made sense

below is the formula i have used

=SUMIF(Company,B12,Total_Cost)

so when i try to display the paid section i get value 0 instead of yes or no

attached is the file

thanks again

Thank you mate your a star quick reponse, i have been on this for 2 days trying to solve it one more question when i now try to add a sale in the sales section instead of showing the latest date it adds the data together do i again use the index and match feature to get that working aswell ?

also a question now that it matches the total cost with yes or no will this formula also update when a new sale is added so that it will show the latest date instead of the first date.

so basically when i add a new sale i want it to show the latest date instead of the first date that appears

regards

Hi Mate,

thank you for your help, i have tried to copy the same formula into my worksheet but it now shows the dates as 1990 and also shows the total cost empty, im i doing something wrong with the forumlas ?

attached is the new one i used just to copy the formula over and it shows as blank

thanks for telling me lol, but i got it working now but the only problem i got is some figures do not show would you know what that can be ?sorry to proper be in the pain in the **** i proper owe you one

Hi Mate,

i have managed to solve this me thanks you are a star mate owe you a drink for sure

FOR SURE I WILL LOL thanks again yassas

Hi Mate,

i have been trying to see if i can use your command and instead of grouping the latest date to be displayed will i be able to display all the sales that has been unpaid so for example group all the unpaid into a summary report

so basically if i have

customer
A - paid
B - unpaid
C -unpaid
B - paid
A - unpaid
A - unpaid
A - unpaid

is there a formula that will filter all the unpaid into one summary sheet

thanks

i tried but somehow got a blank information

i have attached for you to have a look

cheers mate

thanks mate

your a star

i guess if i want to change the criteria instead of no and look at names then i would change that to the specific name i require

regards