I need to sum the rows in a column that meet certain criteria.
column A= date
column B= has $ values
column c= has the dollar values I want to sum if the folling conditions are
met:

Column A date = January (01/01/09-01/31/09)
column B "0"

resulting in sum of column c values

thanks!

=SUMPRODUCT((MONTH(A2:A100)=1)*(B2:B1000)*(C2:C10 0))
Note that range sizes must be equal, and you can't callout entire column
(unless using XL 2007)

If you need more exact dates, could use:
=SUMPRODUCT((A2:A100=DATEVALUE("1/1/09")*(A2:A100<=DATEVALUE("1/31/09")*(B2:B1000)*(C2:C100))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"joe@malvern" wrote:

I need to sum the rows in a column that meet certain criteria.
column A= date
column B= has $ values
column c= has the dollar values I want to sum if the folling conditions are
met:

Column A date = January (01/01/09-01/31/09)
column B "0"

resulting in sum of column c values

thanks!

formula does not give me an error, however it returned a value of $0 when it
should have been $42,000 (6 january rows).

here is the formula as I entered it...do you see my error? thanks again for
your help

=SUMPRODUCT((K3:K299=DATEVALUE("01/01/09")*(K3:K299<=DATEVALUE("01/31/09")*(O3:O2990)*(M3:M299))))



"Luke M" wrote:

=SUMPRODUCT((MONTH(A2:A100)=1)*(B2:B1000)*(C2:C10 0))
Note that range sizes must be equal, and you can't callout entire column
(unless using XL 2007)

If you need more exact dates, could use:
=SUMPRODUCT((A2:A100=DATEVALUE("1/1/09")*(A2:A100<=DATEVALUE("1/31/09")*(B2:B1000)*(C2:C100))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"joe@malvern" wrote:

I need to sum the rows in a column that meet certain criteria.
column A= date
column B= has $ values
column c= has the dollar values I want to sum if the folling conditions are
met:

Column A date = January (01/01/09-01/31/09)
column B "0"

resulting in sum of column c values

thanks!