Formula too long

[dem86]

I am working on building a summary sheet that pulls data from a pivot table. The pivot table pulls data monthly. The summary sheet has all months of the year pre-defined and thus will have months without any data in the pivot table. I was trying to use the if(iserror code to write a "$0" in the out months but my code is too long. Wondering if you have any thoughts on how to make this usable.

Please Login or Register  to view this content.

Thanks!

[DonkeyOte]

You could perhaps try:

Please Login or Register  to view this content.

[dem86]

Thank you very much!!!!