Sumif over multiple ranges

[blindbe2]

I'm trying to sum over 4 weekly ranges if the corresponding range is greater than zero.

Formula is:
=SUMIF(O4:O10,O14:O20,O24:O28,O32:O37,">0",K4:K10,K14:K20,K24:K28,K32:K37)

The problem seems to be in the O32:037 as it doesn't turn a color like the other ranges when it is entered. Additionally the entire sum range does not turn a color.

is there another way to do it that is permissible? Right now it is returning a #value error in the destination cell.

Thanks

 

[barry houdini]

I don't believe you can use multiple ranges with SUMIF, what's in the intermediate cells i.e. O11, K11, O12, K12 etc.?

 

[blindbe2]

This is a 2 week example. I'd like to total after each week and have a monthly total at the end. The "?" represents where I'm trying to get the #WIN and #PD to total.

Milwaukee Contracts 2006.xls
	K	L	M	N	O	P
3	# WIN	#PD	# OTHER		JIM A.	BUD
4	2				250
5		1				575
6	6				330
7	10				2,550
8
9
10
11	18	1	-		3,130	575
12
13	# WIN	#PD	# OTHER		JIM A.	BUD
14		6				3,826
15	32					14,200
16		6			4,120
17	44				19,850
18
19
20
21	76	12	-		23,970	18,026
22
23					JIM A.	BUD
24	94	13	-		27,100	18,601
25
26				#WIN	?	?
27				#PD	?	?
Jan

 

[blindbe2]

I figured it out myself. Sumif function does not support multiple ranges as a single function. My final function:

=SUMIF(O4:O10,">0",K4:K10)+SUMIF(O14:O20,">0",K14:K20)+SUMIF(O24:O28,">0",K24:K28)+SUMIF(O32:O37,">0",K32:K37)

This works well.