LinkBack URL
About LinkBacks
Hello
I need a solution where there are empty cells next to digit 1 enter a sum of the prices that are next to digit 2,
the problem is that I have a lot of lines and my array is changing I will probably need a macro.
Hello
I need a solution where there are empty cells next to digit 1 enter a sum of the prices that are next to digit 2,
the problem is that I have a lot of lines and my array is changing I will probably need a macro.
Try this formula in J4:
Enter with Ctrl+Shift+Enter to create an array formula. You can then copy the formula to J13 and further down as required.
Please Login or Register to view this content.
Does that work?
WBD
Office 365 on Windows 11, looking for ✶ rep!
You could add a helper column, then use a SUMIF.
In K4:
Formula:
Please Login or Register to view this content.
In L4:
Formula:Please Login or Register to view this content.
Copy both down.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
no, this no work
Not sure who that is directed at. See attached for implementation of my formula.Originally Posted by omri_k
WBD
this not working
so...why not upload a ,sample file with lot a lines...and someone might be kind enough to incorporate the formula into vba....problem is that I have a lot of lines and my array is changing
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
As above, tricky to help with limited feedback. The formula in the attachment I provided clearly *is* working. I'm not clear on what you need.this not working
WBD
Here is an easy to understand loop macro...
Please Login or Register to view this content.
sorry this working
tnx man
I like this
wow i must learn vba this is amazinghere is an easy to understand loop macro...
Please Login or Register to view this content.
If this solves your initial requirement, then please mark thread as solved...
I'm new to this site How do you do it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks