Company purchase the items whose details are in purchase table but we found some items faulty, shows in faulty table. We want the total amount of purchase in g12, the amount of faulty products in h12 and net pay amount in I12. How to solve this?
If column G in 'purchase' table contains the cost amount and column H contains the value of the faulty items then:
In G12: =sum(G1:G11)
In H12: = sum(H1:H11)
In I12: = sum(G12-H12)
Mel
Yes ..thank you so much Mel..probelm got solvedWhy not add a further column to the 'Faulty' table to show monetary value so that it is then 'Purchase' table value minus 'Faulty' table value (G12-H12=I12)
Mel