Please check the attached sheet.
Please check the attached sheet.
hi Sarangsood. you can do it like this:
i commented off the MsgBox line. that's another way you can do it. remove the line above it & remove the single quote before the MsgBox to try it outPlease Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Try this.....with SUMIF
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
@sktneer : i inserted your module. now how should i proceed ?
Click anywhere inside the code and hit F5.
Please find the attached sheet.
Here you will find a module SumIf. Run this module as stated above.
Last edited by sktneer; 11-05-2013 at 03:09 AM.
but it is giving me the sum of 6700+6800+6900+7000. but i want the cell to tell me 6700+6800+6900+7000 not the sum which is 27400.
If that is the case benishiryo's code will do the trick. Probably I misunderstood your requirement.
@benishiryo : your code is working fine , but is there a way i can use it as a formula. actually the problem is i am using real time data , so i want them to change automatically.
i'm not really into VBA, so maybe others can chip in. this Function below will allow you to input the range & criteria. downside (if your equation is not always using ">") is that i don't know how to change the operator through the formulas in Excel:
same thing. just paste inside the VBE window. you can then go back to the spreadsheet & use a new formula i named ResultInfo. you need to put in the range & criteria like:Please Login or Register to view this content.
=ResultInfo(A1:A6,D1)
perfect. what i can do for ">" problem is that i can make another vba with different name with "<".
thanks a lot
Slight change in Beni's Code...
=EvaluateSumif(A1:A6,">"&D1)Please Login or Register to view this content.
=EvaluateSumif(A1:A6,"<"&D1)
=EvaluateSumif(A1:A6,"<="&D1)
=EvaluateSumif(A1:A6,">="&D1)
Last edited by :) Sixthsense :); 11-05-2013 at 05:13 AM.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
thanks a lot. solves the problem. thanks a lot sixthsense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks