LinkBack URL
About LinkBacks
MWSnap091 2014-01-03, 17_04_57.jpg
I want to sum "all the cell" which it's left = "2013-5", how to do this?
be careful , some cell set to text format and I use excel 2003 version only
must use vba to solve??
attached excel
ThanksHOW TO.xls
sum multiple columns based on specific condition
MWSnap091 2014-01-03, 17_04_57.jpg
I want to sum "all the cell" which it's left = "2013-5", how to do this?
be careful , some cell set to text format and I use excel 2003 version only
must use vba to solve??
attached excel
ThanksHOW TO.xls
Last edited by chiwing; 01-03-2014 at 05:37 AM.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
pls let me know which column you want to use for sum ???
@rishikrsaw
Why are you responding to this thread when Pepe has already pointed out that the thread does not have a valid subject?
With 93 posts behind you, you really should know better than this. The fact that you already have infractions recorded gives me no leeway and I'm about to issue another one.
Take particular note otherwise it's quite likely that any further infractions may result in an outright ban.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
@Richard Buttrey
sorry for inconvenience cause
I just overlook Pepe's comment ...
I m quickly removing my this posts...
I have correct the subject of this threadOriginally Posted by Richard Buttrey
can any people help?
column that I want to sum: column in D to AS which are number properties
Last edited by chiwing; 01-03-2014 at 09:30 AM.
chiwing, from what I can tell it looks to me like your thread title still does not meet forum rules.
Perhaps I can help you a little w/o breaking any forum rules, it looks to me like you are trying to sum multiple columns based on specific values.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I can't edit #1 anymore
I want to sum multiple columns based on specific condition ,but the value I want to sum is not the column searched,, but the right of it
Send a PM to a Moderator and ask them to change it for you.
You can see a list of Moderators who are on-line on the Home page (they are coloured green).
Hope this helps.
Pete
Thread title has been changed. Happened to see this post and came to it.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
can any1 post the vba code.
the difficulties is to sum nearby column, not column which satisfied condition
Big Thankyou
Last edited by chiwing; 01-03-2014 at 10:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks