sumproduct
 

This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)

I can't get this formula to work for February....etc. I need to use the
same range of cells.

Please help.

sumproduct
 

Check your other post.

RGlade wrote:

This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)

I can't get this formula to work for February....etc. I need to use the
same range of cells.

Please help.

--

Dave Peterson

sumproduct
 

If you change =1 to =2 and your col B is properly formatted dates, it will
work for Feb to sum col D
This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)
Try , instead of *
This is what I am using: =sumproduct((month(B5:B412)=1),D5:D412)

--
Don Guillett
SalesAid Software

"RGlade" wrote in message
...
This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)

I can't get this formula to work for February....etc. I need to use the
same range of cells.


Please help.

sumproduct
 

I'm just getting ready to try it. Thank you.

"Dave Peterson" wrote:

Check your other post.

RGlade wrote:

This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)

I can't get this formula to work for February....etc. I need to use the
same range of cells.

Please help.

--

Dave Peterson