Sum of individual values in a Cell

[riteshkp]

Folks - Need some help here. I have searched the forum and haven't been able to locate this specifically.

I have a sumif function that adds up all the values in a column based on set criteria in another column. Is there a VBA Code/Macro that would convert this sumif value into the sum of individual numbers. For instance, the output instead of being a single number should be something like = SUM(258, 712, 556, 478, 412, ...etc).

This way, I need to exactly know which numbers have gone into the Sumif. Please help.

Thankyou

 

[Gerald Higgins]

Why not use a helper column to insert a flag - for example an "X" character, next to each value that meets the SUMIF criteria ?

 

[riteshkp]

I have done that...used the helper column to bring the total output of the SUMIF function. Our Project Manager wants to see the actual values in there, rather than the final figure. i.e. the final output instead of =2416 should be =258+712+55+478+412. Is this possible?

Alternately, my file has set of numbers in consecutive rows (eg: E6:E14). Is there a code that can convert this into the values in each of these corresponding cells: =E6+E7+E8+E9+E10+E11+E12+E13+E14.
This pattern repeats in other columns as well, with different set of consecutive rows.

 

[Gerald Higgins]

I can't see
a) how to do this
b) what value doing this would add

How about using a helper column, and instead of a simple "X" to flag that that value meets the SUMIF criteria, instead copy the value into the helper column.

Something like this

1..........
2....2....
3..........
4....4....
5..........

Where 2 and 4 meet the SUMIF criteria, and 1, 3, and 5 don't.