View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Lost in Query Lost in Query is offline
external usenet poster
 
Posts: 1
Default How do I sum numbers thru specifying the amount from another cell?

I cannot get SUMIF to work for me at all.

I have a Sum Range F9:F129 = numbers
I have a Criteria Range A9::A129=Dates
and I have a Criteria M2 (TODAY)
I want all numbers in the range F9:F129 to be added thus SUM all up to TODAY
<=M2 depending on Dates in column A9:A129 but it just comes back with nil it
doesn't seem to recognise that M2 is a number (TODAY) and thus it will not
calculate anything.

Chris