hi,
i want to add a total row after each name that display desire sum.my problem is clear please see attached file in my post
hi,
i want to add a total row after each name that display desire sum.my problem is clear please see attached file in my post
If you want to ADD a row containing the total, that will require VBA. If that is OK with you, I will move your thread to the correct sub-forum. Please confirm.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
not require VBA. i only want to ADD a row containing the total.
You can't. The next best thing might be something like this:
=IF(A3<>"",SUM(C$2:C2)-SUM(D$1:D1),"")
This is better...
=IF(A3<>"",SUM(C$2:C2)-SUM(D$1:D1),IF(C3="",C2,""))
Can we like this
1. First we count merged row in name column. 2. For counted rows sum price from Rohan's first row to counted row. 3. Add row containing sum after counted row. 4. DO this for next i.e Sohan…and so on…
You could use Grouping with Subtotals but, for that, you would need to repeat the names.
https://support.microsoft.com/en-us/...e-b0a3d4a52b3a
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You can't add rows automatically without VBA.3. Add row containing sum after counted row.
1. I have given you a workaround.
2. You don't like it.
3. It needs VBA.
4. you don't want VBA.
5. Good Luck, but I'm out.
I'm confused.
I did what TMS suggested. The output was exactly as your sample indicates. I did have to move your sample output range below the source data so the rows lined up.
What am I missing?
Last edited by FlameRetired; 02-09-2022 at 04:18 PM. Reason: Uploaded file
Dave
@FR: I didn't think you'd get away with leaving the merged cells as they are. Seems you can. Who'd a thought? Looks exactly as required
I note that the merged cells present a problem should the OP wish to insert rows, but I suspect that would be a problem with the original layout.
Yeah I was confused about the insert rows part. I couldn't see where the sample output reflected that. I am not sure I am grasping the concept.
Well, I guess we have done what we can … and it doesn’t involve VBA. So, we just sit back and wait for some feedback.
Thanks Glenn kennedK and FlameRetired
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks