In English

=SUMPRODUCT(--(E2:E200=N2),--(K2:K200<100)

you cannot use whole columns with SUMPRODUCT prior to Exel 2007

--
__________________________________
HTH

Bob

"Rockbear" wrote in message
...
Hi

I have two sum function that work as they should, but try to set another
agrument and then it fails..
First one :
=ANTALL.HVIS(E:E,N2), in english i thin it is NUMBER.IF(E:E,N2)
I am trying ti get it to say NUMBER.IF(E:E,N2 AND K:K<100)
IF the E:E finds the value of N2, and the number in K:K is less than 100
it
should count all under 100.
The same with 101 t0 300 NUMBER.IF(E:E,N2 AND K:K100 and 300)


Second sum the numbers :
=SUMIF((E:E,N2,K:K)
=SUMIF((E:E,N2 AND K:K<100)
Sum all numbers from 0 to 100 in K:K if N2 are found in E:E
=SUMIF(E:E,NR AND K:K100 and 300)
SUM all numbers between 101 and 300 if N2 are found in E:E


Would have been wonderfull with some help

ROCK-
Just a regular user