Data validation

Hi all,

can you tech me how to use data validation wisely.

I know how to put validation max number on entry column.

but can i do it on sum table?

1)

exp : based on attachment file "capture"

what I fill = "quantity' & "unit price"

data I want valid = sum for 5 column on "total price " can't be more than 450(table sum is 482)

2)

exp : based on attachment file "d"

Row 1(QC) & Row 2(ASS) is total sum from other spreadsheet

Row 3 is total sum for row 1 and row 2.

can I put validation data on row 3 can't be more than budget?

really appreciate on help.

thank you,