How to SUMIF multiple ranges?

[karesz]

Hello!

As You see I have got a production statistic dayly. I need to sum i
weekly
on the end of the month. I need to do this manualy every time. I woul

like to define a name: range for each week. SUMIF and DSUM is not ok,
because these just summing the firs column of the range. Ineed to d
this with one formula. To sum it first in one column and than use thi
column in SUMIF is not ok.

Thanx for help.

Charles Cse

+-------------------------------------------------------------------
|Filename: How.zip
|Download: http://www.excelforum.com/attachment.php?postid=4021
+-------------------------------------------------------------------

 

[Guest]

Most knowledgeable users will not open attachments. If you will post a good
text description, you will likely recieve a prompt answer.

As a general suggestion, your subject line suggests that you might be able
to use SUMPRODUCT along the lines of
=SUMPRODUCT(condition1*condition2*range)
or multiple SUMIF's along the lines of
=SUMIF(range1,cond1)+SUMIF(range2,cond2)+...

Jerry