SUMIF with two conditions ?

C

Calvin

:cool: 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
 
B

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?
 
F

Frank Kabel

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