Calculating balance inventory by type of product. Sumif formula?

[simplyxl]

Hi,

I need help to be able to manage my inventory w.r.t to receipts and delivery. Enclosed is a spreadsheet with expected result in column C. Colum H has Plus inventory and Column Q has Minus Inventory.

Values related to the type of Product in Column A, F and Q are added manually, and I would like to know my exact inventory in Column C.

Column C = (Column B + Column H) – Column Q by type.

Thanks for the help. Please let me know if any clarification is needed.

Thank you!

[boopathiraja]

Try, Put it in C3, and Drag it Down

=SUMIFS(B:B,A:A,A3)+SUMIFS(H:H,F:F,A3)-SUMIFS(Q:Q,O:O,A3)

[hoyasaxa215]

Please see attached. Please respond is this is unclear or if you have any questions.