How to total owed column.

[nicka1234]

I need to know how to populate the "daily total owed" column, I have a "payment recieved" column a "payment Required" and a "job completed" column, how can I populate "daily total owed" with the "payment Required" if "job completed" is (Y) but "payment recieved" (N)?

[dredwolf]

Could you upload a sample, with a couple of examples showing what you would like ?

[nicka1234]

excel.jpg

So I want to know if there is a way to total the "payment owed" but only if "job Completed" is "Y" and "Payment Received" is "N"

Does that make sense?

Cheers

[dredwolf]

I can't work with a screenshot, especially as it contains NO information
Please upload a sample workbook (see my signature below for info on HOW to upload a sample)

[nicka1234]

Upload.xlsx

Better?

[dredwolf]

Much, Thank You
1 question, you uploaded a 2007+ style workbook, but profile says 2003...which solution type do you need ?

[nicka1234]

2007 awkward...

[dredwolf]

Okay using your sample ( with the day that has values) I put this in cell B24:

Please Login or Register  to view this content.

formatted the cell as currency, as your range sizes for each day are different, you will have to adjust each range for each day

I added some data, just to show how the formula works
(See attachment for the additions I made

Hope this helps

[nicka1234]

You my friend, are a genius. Thank you, I swear I've been sitting here for the past hour trying to figure it out!

Thanks again!

Nick

[dredwolf]

You are welcome

Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"

EDIT-
For 2003 the formula would have been:

Please Login or Register  to view this content.

just an FYI

[nicka1234]

Will do, actually I saw a fair bit of "=sumproduct" on my hunt to work it out haha.

Thanks again,

Nick

[dredwolf]

It is not a problem
Sometimes Sumproduct is actually..(dare I say it?)..'better'/'easier', but you should use sumifs when the criteria are straitforward like this, sumifs is faster than sumproduct, as it is optimized for this type of work, sumproduct is for when the criteria get 'strange'..