Hello,

I need to find a way to show the cell values that are being used in a SUMIF formula. For example, let's say I have a 5 in cell A1 and a 2 in A2. I write a SUMIF in cell A5 that adds up all the numbers greater than 0 in my range of A1:A2. What I want this macro to do is show "=5+2" in the next column (B5). My macro skills are not sufficient to even know where to start, but I sure would be grateful if someone could help me out with this.

The ideal macro would allow me to select several SUMIF functions and perform this task for everything I have selected.

This will be used to consolidate financial statements but allow another user to see which values are being used. I have a a few hundred rows of data and I'm going to code each row to one of 20 general categories - Repairs & Maintenance or Miscellaneous Income, for example.

Thank you!