MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Desperate, need help!


Posted by Carla on August 23, 2001 10:30 AM

I need a lookup function that will automatically sum all of the data from January until today()-31 based on today's date. I know the basics of lookup functions but this is beyond me. How do I tell it to sum. Please help.
Here is the format of my table:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
data



Posted by mseyf on August 23, 2001 12:07 PM


I couldn't understand from your table format where the dates are and where the data is, but I assume you're going to have to use a SUMIF() formula. For example, if the dates are in column A and the data is in column B, the formula would be:
=SUMIF($A$1:$A$15,"<"&NOW()-31,$B$1:$B$15)

Hope this can get you started.

Mark