Sumif function for date range in a data base

[BRIITO]

I HAVE A DATA BASE WITH AMOUNTS $$ AND DATES, AND WANT TO USE THE SUMIF FORMULA TO ADD AMOUNTS THAT < OR = TO A DATE. LIKE ADDING ALL AMOUNTS FROM JAN1 TO JAN31 (OR <= JAN31).
THIS IS WHAT I´M DOING:
=SUMIF(Base_Datos!$J:$J;"<C15";Base_Datos!$M:$M) WHERE C15 HAS A DATE.

CAN ANYONE GIVE ME A HAND??

 

[Domenic]

Try...

=SUMIF(Range,">="&A2,RangeToSum)-SUMIF(Range,">"&B2,RangeToSum)

...where A2 contains the start date, and B2 contains the end date.

Hope this helps!

 

[BRIITO]

sorry...formula got cut when I pasted it...here it is

=SUMIF(sheet1!$J:$J;"<C15";sheet1!$M:$M)

c15 has a date...

thanks

 

[Domenic]

Try...

=SUMIF(Base_Datos!$J:$J;"<"&C15;Base_Datos!$M:$M)

Hope this helps!

 

[BRIITO]

great!! problem solved....thanks a lot for the help!