I am new to excel. Please help me solve this.

[Brijim]

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?

 

[Mel Smith]

Welcome to the Board! It will help to see an example of your spreadsheet.

Mel

 

[Mel Smith]

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

 

[Brijim]

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

 

[Mel Smith]

Why 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

 

[Brijim]

Why 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

Yes ..thank you so much Mel..probelm got solved

 

[Mel Smith]

I’m pleased I could help and your problem is solved.

Mel