SUMIF problem

R

richierich1961

I am trying to use a SUMIF function to add figures from column A when the
corresponding entry in column B (which is a date) is less than a year ago.
To try and make things easier I have a formula in c1 which carries out the
date calculation =TODAY()-365. I have tried various formulae but have not
been able to achieve a successful result - my latest effort is
=sumif(b:b,>c1,a:a) and I have also tried =sum(if(b:b>c1,a:a,0)). Can anyone
help ?
 
O

OssieMac

Hi,

Try entering the criteria in text format by concatenating the greater than
sign and the cell as per the following example:-

=SUMIF(B:B,">"&C1,A:A)

Regards,

OssieMac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top