ExcelBanter - sumif and numberif

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 COUNTIF(E:E,N2)
I am trying ti get it to say COUNTIF(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

--
Just a regular user

"Ashish Mathur" wrote:

What is the question.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Rockbear" wrote in message
...

--
Just a regular user