Hi,

The formula should be

=SUMIF(List!$B$2:$B$65536,"<="& A2,List!$C$2:$C$65536)

Regards,
B. R. Ramachandran


"Bharat Saboo" wrote:

I am trying to add a total in 2 sheet if date in 1 sheet is <= particular
criteria.

the following is my function call

=SUMIF(List!$B$2:$B$65536,"<= A2",List!$C$2:$C$65536)

Please explain why it does not work and how to make it work.

The answer at present comes to zero only.

Thanks