SUMIF with two conditions ?

[Calvin]

OK I have tried just about everything and can not find the righ
combination for seems like a simple problem:

IN A1

IF N79:N83 >=1 AND
IF N79:N83 <=7

THEN SUM K79:N8

 

[JulieD]

Hi Calvin

one way
=SUMPRODUCT(--(N79:N83>=1),--(N79:N83<=7),N79:N83)

Cheers
JulieD

 

[BenjieLop]

Shouldn't there be an ELSE argument on this? What happens then i
N79:N83>7? Is it assumed that when N79:N83>7, cell A1 will return
blank?

 

[Frank Kabel]

Hi
as alternative to Julie's solution:
=SUMIF(N79:N83,">=1",K79:K83)-SUMIF(N79:N83,">7",K79:K83)