Show individual values in a SumIf formula

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!

b5: =if(and(a1>0,a2>0),a1 & " + " & a2)

a5: =sumif(a1:a2,">0")

I appreciate the reply, but that is not what I'm looking for. While that does accomplish getting a cell to say "5+2", I can't copy that into another sheet and have someone else (an auditor) see all the numbers that went into the calculation. Additionally, I have about 975 rows of data and this method would require me to write some extremely long IF statements. I'm looking for a macro that will identify the numbers being summed in my sumif statements, then show the actual math being done in a way that I can copy into another sheet and it would show =5+2 (in the real world scenario, there would be many more cells being added together). Thanks!

The best way to help you would be a non-sensitive sample in excel

Good idea. Here is a doctored version which should show clearly enough what I'm trying to do. Thank you.