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