Need Help Excel Formula

[woodchuck]

Ma'am/Sir

I need help in here:

Supposed i have this data

Cell subs A B C D E F G H
1 20 200 20 2 3 1 3 1 4
2 24 200 30 2 3 1 3 1 4
3 30 100 50 2 3 1 3 1 4
and i need to meet this conditions

X = sum of A/( sum of B- sum of C-(sum of D- sum of E)- sum of F) of cells with subs >= 20

Y = sumA/(sumB-sumC-(sumD-sumE)-sumF) of cell with subs >= 20 and B >= 50


problem is i have thousands of cells to sum up

thanks

 

[woodchuck]

 

[Joe4]

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=551008

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).