I'm using this formula to sum up a row of data:
=SUMPRODUCT(($B$2:$CB$2="Revenue")*($B93:$CB93))
Yet, this data spans the range of the entire month. So on a day where there's no data yet (like tomorrow!) I get a #N/A in the cell. And when it's total using the above formula - I get an #N/A also. Is there anyway to sum it up so it totals what I have so far and ignores the dates that haven't been filled in yet?
Thank you!
AW
=SUMPRODUCT(($B$2:$CB$2="Revenue")*($B93:$CB93))
Yet, this data spans the range of the entire month. So on a day where there's no data yet (like tomorrow!) I get a #N/A in the cell. And when it's total using the above formula - I get an #N/A also. Is there anyway to sum it up so it totals what I have so far and ignores the dates that haven't been filled in yet?
Thank you!
AW