=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