J
James S
Hi Heidi,
If I follow what you are trying to do, this may work:
A B C D E F G
1 VENDOR INVOICE# ACT PAYMENT TAX TOTAL PROJ #
2 Ace 99999 D700 10.00 .70 10.70 D3F37
3 A1 222 5.00 .35 5.35
..
..
10 D3F37
11 Deposits
12 Payments =SUMIF(G:G,$A$10,D
) (formula for B12)
13 Sales Tax =SUMIF(G:G,$A$10,E:E) (formula for B13)
14 Balance =SUMIF(G:G,$A$10,F:F) (formula for B14)
If you change the project number in Cell A10, the formulas
in B12:B14 will update accordingly.
Hope this helps or gives you some ideas.
Regards,
James S
If I follow what you are trying to do, this may work:
A B C D E F G
1 VENDOR INVOICE# ACT PAYMENT TAX TOTAL PROJ #
2 Ace 99999 D700 10.00 .70 10.70 D3F37
3 A1 222 5.00 .35 5.35
..
..
10 D3F37
11 Deposits
12 Payments =SUMIF(G:G,$A$10,D
) (formula for B12)13 Sales Tax =SUMIF(G:G,$A$10,E:E) (formula for B13)
14 Balance =SUMIF(G:G,$A$10,F:F) (formula for B14)
If you change the project number in Cell A10, the formulas
in B12:B14 will update accordingly.
Hope this helps or gives you some ideas.
Regards,
James S