I want to add the values of all of the cells from another table, up until the
date selected. To explain, I have a table with values for each month of the
year and would like to add all of the figures together to get the total on a
seperate summary worksheet. That is not the problem. But how do I tell the
computer to only add up certain cells, say from january until may, even
though I have data going until september? I was hoping i could do this with a
lookup function (i.e. =sum('Sheet 1'!b23:hlookup(E2,'sheet 1'!A12:N27,12,
false) - where sheet 1 has the values in row 23 - 12 rows down from the names
of the months and cell e2= the month that i want the computer to sum up to
[may]) but this is not working. any suggestions.
please explain clearly - i am not so familiar with all of the functions.
Thanks for the help.