Excel going to make me cry....

[paulrockliffe]

What is wrong with this formula:

=SUM(W7:W9,">V6",Y7:Y9)

V6 = 1000
W7:W9 are numbers greater than 1000
Y7:Y9 are other normal numbers.

I get a #VALUE! error, but what I've done seems to be right?

HELP!

[paulrockliffe]

Er.....obviously that should be SUMIF.....

[paulrockliffe]

Needs to be in this format:

=SUMIF(N7:N8,">"&$M$6,R7:R8)

Sorted.