hi, bosco... thanx and sorry for late to respond, i had some issues here but
ur's 2nd solution worked for me and it resulted correctly till now. if any issues raised i will inform you, again i have uploaded all solution for others.
thankyou
with regards
relio:)
hi, bosco,
your sol. saved me, friend, thanx for working on this problem,
just for curiosity asking, am really sorry, can we solve it without adding a new column becoz as narayan's sol. (separation of suffix & summing values) was a straight way solution with adding a column to data...
hello,
1) sol. its not working for other values (its good to avoid table)
2) sol. i don't want values get separated with suffix, when items are filtered then sum-up of qty will be shown in the top row
3) sol. working fine, i tried this, data on 1-sheet and result on another but here (others...
hi, rahul & to all i saw power query and Pivot table with Slicer is a good and neat way of data representation, but here it needs like "put the formula & get the result", personally i would like to learn more on power query and Pivot table with Slicer. thanx for this. i have uploaded all three...
Hi, thanx for response (David), adding another column for suffix is a straight solution, but here boys carelessly put any suffix, so as per bill (some time may have / may not have suffix), i need the solution (summing up values with suffix) which can trim all suffix inside the formula and then...
hello, this is relio new here, i have problem and uploaded xl-file for reference
simple daily account data contains figures with suffix needed to sumup the values by the reference of items on left, i tried subtotal with sumproduct and messed up.
thanx in advance for any help.
relio