Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum with criteria
I have an invoice & payments tracker for sub-contractors, im trying to create
a formula which will allow me to calculate how much each contractor is owed. For each job, the subbie is allocated a proportion of the total invoice, and gets paid when the client pays At the moment I have something like this: Subbie Subbies commission Date Client Paid Adam 100 John 200 1/09/2005 John 50 Adam 300 5/09/2005 John 100 I need a formula to add all of Adams commissions which have NOT been paid by the client, ie = 100 Then another formula to add all of Johns commissions which have NOT been paid by the client, ie = 150 Im sure its really simple, Ive been trying to figure it out but keep getting #VALUE errors Thanks heaps! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |