SUMIF formula not working

[bopsgtir]

=SUMIF(D4:D24,$D4>$A$1,C4:C24)



can someone tell me where i have gone wrong with this formula

D4:D24 are dates with a =DATE(YEAR(TODAY()),MONTH(TODAY()),29) formula

and A1 is a =today()

what im after is any date that has past todays date then add the £ cost from column C

[NBVC]

try:

=SUMIF(D4:D24,">"&$A$1,C4:C24)

[bopsgtir]

no thats not working it just brings back the result as FALSE

[NBVC]

I don't think SUMIF ever returns FALSE.

Are you sure you used my formula?

It sums column C where column D is greater than the entry made in A1

[mahju]

NBVC's formula works.

another way is

Please Login or Register  to view this content.