Does SUMIF in Excel, take multiple criteria input?

[Xray_Dave]

I am trying to SUM by month, what is spent on different products or buckets.
The formula I have been trying to make work is:
'=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) where:

RANGE=D10:E40. Months are in Col D10:D40, and buckets are in E10:E40.
CRITERIA=(AND(MONTH(1),G3))
SUMRANGE=F10:F40
I have tried several others but don't seem to get even close.
Thanks
Dave

[Peo Sjoblom]

=SUMPRODUCT(--(ISNUMBER(D10:D40),--(MONTH(D10:D40)=1),--(E10:E40=G3),F10:F40
)

--

Regards,

Peo Sjoblom

"Xray_Dave" <[email protected]> wrote in message
news:[email protected]...
> I am trying to SUM by month, what is spent on different products or
buckets.
> The formula I have been trying to make work is:
> '=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) where:
>
> RANGE=D10:E40. Months are in Col D10:D40, and buckets are in E10:E40.
> CRITERIA=(AND(MONTH(1),G3))
> SUMRANGE=F10:F40
> I have tried several others but don't seem to get even close.
> Thanks
> Dave

[Scott Wagner]

Take a look at these:
http://www.cpearson.com/excel/array.htm
http://www.contextures.com/xlFunctio...tml#SumProduct

"Xray_Dave" wrote:

> I am trying to SUM by month, what is spent on different products or buckets.
> The formula I have been trying to make work is:
> '=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) where:
>
> RANGE=D10:E40. Months are in Col D10:D40, and buckets are in E10:E40.
> CRITERIA=(AND(MONTH(1),G3))
> SUMRANGE=F10:F40
> I have tried several others but don't seem to get even close.
> Thanks
> Dave

[Xray_Dave]

Scott Wagner,
Thanks for the references, they were right-on target.
Xray_Dave

"Scott Wagner" wrote:

> Take a look at these:
> http://www.cpearson.com/excel/array.htm
> http://www.contextures.com/xlFunctio...tml#SumProduct
>
> "Xray_Dave" wrote:
>
> > I am trying to SUM by month, what is spent on different products or buckets.
> > The formula I have been trying to make work is:
> > '=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) where:
> >
> > RANGE=D10:E40. Months are in Col D10:D40, and buckets are in E10:E40.
> > CRITERIA=(AND(MONTH(1),G3))
> > SUMRANGE=F10:F40
> > I have tried several others but don't seem to get even close.
> > Thanks
> > Dave

[Xray_Dave]

Peo Sjoblom,
Thanks for your reply, they were of great help.
Xray_Dave

"Peo Sjoblom" wrote:

> =SUMPRODUCT(--(ISNUMBER(D10:D40),--(MONTH(D10:D40)=1),--(E10:E40=G3),F10:F40
> )
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Xray_Dave" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to SUM by month, what is spent on different products or
> buckets.
> > The formula I have been trying to make work is:
> > '=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) where:
> >
> > RANGE=D10:E40. Months are in Col D10:D40, and buckets are in E10:E40.
> > CRITERIA=(AND(MONTH(1),G3))
> > SUMRANGE=F10:F40
> > I have tried several others but don't seem to get even close.
> > Thanks
> > Dave
>
>
>