AddEveryOtherColumnIfDateLessThan.png
I have the attached summary view. I'm looking for a formula that can sum all the values in the hrs column for a particular person and project and for only the dates that are less than or equal to a given date (in cell B9). I've worked out how to sum every other column with the following formula:
{=SUM(IF(MOD(COLUMN($E3:$R3),2)=1,$E3:$R3,0))}
but I can't seem to modify it so that it locates a certain person (cell B11) and a certain project (say, cell B8) that is less than or equal to the date in cell B9. Any ideas?
Bookmarks