Formula involving pivot data

[SharpL]

Hello,

I have a formula (shown below), which totals some figures from a pivot table. However, some figures do not exist when the category has no data for that particular day.

How can I fix the formula so if no figure exists?

Please Login or Register  to view this content.

I attempted IFERROR, but couldn't get it to work.

Thanks in advance

[SharpL]

Post bump

[SharpL]

Anyone? lol