can someone please help me solve this problem by formula or VBA. (refer to formula). Sorry for my bad english.
i have the input1, and i want the formula auto sum the input 2 which between the the value of input 1, And give the result column.
input1 input2 result 200 3 4 7 200 3 8 5 12 28 250 54 34 3 4 7 102 100 9 9 200 10 10
Thank you for your help.
Please help me
Try this, copied down in C2...
=IF(A2="",B2+C1,B2)
If you dont want to see the intermediate values, try using Conditional Formatting to make them appear invisible.
1. highlight the range you want to apply the conditional formatting to (C2:C14 in this case - adjust as needed)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A3="" set font color to white
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this...
Data Range
This formula entered in C2 and copied down:
=IF(OR(AND(A2<>"",A3<>""),AND(A2="",A3<>""),B3=""),SUM(B$2:B2)-SUM(C$1:C1),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you. It's very helpful to me. It work both way for me. I learn alot
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
Can i ask excel experts one more problem please? I tried to figure out the formula but i can't due to my limitation of excel skill.
i have the same input1 and i want to calculate the input2. i want to have the result from the input2 (as file attach)
result = B2 + A3 - B3
please help me if there is a formula(refer) or VBA (please show me where to copy)
input1 input2 result 20 200 50 170 200 30 220 250 5 275 100 80 25 20 60
Last edited by vho; 05-06-2014 at 04:31 AM.
I can follow this much:
20+200-50 = 170
After that I'm completely lost!
may be this full file could give some idea. And if its ok, can you solve the column Cal. As well please.
Last edited by vho; 05-07-2014 at 03:58 AM.
Sorry, still confused.
Thank you very much for your time
You're welcome!
Good luck!
This array formula (confirm with ctrl+shift+enter)
=IF(AND(NOT(B2=""),COUNTA($B$2:B2)>=2),INDEX($A$1:A2,MAX(IF($A$2:A2="",0,ROW($A$2:A2))))+INDEX($B$1:B1,MAX(IF($B$1:B1="",0,ROW($B$1:B1))))-B2,"")
in C2 and copied down will return the results you have in your example.
it gave me the #value# (170, 220,...) where it support to show number. if this formula work. can u give me the sample as well please.
Example is attached. Make sure you enter the formula using CTRL+SHIFT+ENTER because it is an array formula.
thanks it's working.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks