If cell in one sheet1 turns green, cell in sheet2 recalculates total

hey everyone,

i doubt this is possible

but is there way to to have sheet 1 AE3 influence sheet2 P4:Y4 and clear out anything listed under Low risk Breach.

i was thinking that if sheet1 AE3 turn green, is it possible to clear sheet2 P4:Y4 of any data

back story: Basically data in Sheet 1 are the amount of times that individual breach happened through 25 audits, and Sheet 2 is just counting the number of breaches them selves. so 1 breach could have occurred in 25 audits for that company (E.g. in 'Sheet2' - technical error 7 ( is one breach company A received), but in 'Sheet1' - technical error 7 occurred 25 times in company A

so bascially if there is 3 or less in Sheet1 AE3, i would like everything in sheet 2 P3:Y3 (low risk area) to clear data and recalculate Sheet2 Z3 (total) based on left over data.

example attached

ive also added a dummy solution if anyone is confused- hard for me to explain without showing what is suppose to happen

thankyou again



-

Thanks! ive tried it but its not giving me the right output. i thought of another way to to generate the desired outcome.

how about a formula saying " only count this range (M3:AJ3) if this cell (AP16) is 3 or less?

this probably makes more sense

answer to populate in AM3

only count (M3:AJ3), if (AP16) is more than 3

but if AP16 is 3 or less only count M3:Z3