If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula help
hello,
I have A B C B E 1 c 100 90 c 2 c 100 100 b 3 d 200 80 f 4 d 100 90 d total I need a formula that will add column B and column C only if columns A & B are the same. Thanks! |
#2
|
|||
|
|||
formula help
You probably meant
=if(a2=D2,b2+c2,"") -- Don Guillett Microsoft MVP Excel SalesAid Software "Araseli" wrote in message news hello, I have A B C B E 1 c 100 90 c 2 c 100 100 b 3 d 200 80 f 4 d 100 90 d total I need a formula that will add column B and column C only if columns A & B are the same. Thanks! |
#3
|
|||
|
|||
formula help
I wasn't sure if you're asking for one global answer, or line by line
calculations, so here's both. To get row 1 to do a simple test, put this in E1 and copy down: =IF(A1=D1,B1+C1) To get one answer for the whole table in one cell without the formula above helping, put this formula down below somewhe =SUMPRODUCT((A1:A4=D14)*(B1:B4+C1:C4)) Expand the ranges as needed, but make sure they're all the same size. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Araseli" wrote: hello, I have A B C B E 1 c 100 90 c 2 c 100 100 b 3 d 200 80 f 4 d 100 90 d total I need a formula that will add column B and column C only if columns A & B are the same. Thanks! |
#4
|
|||
|
|||
formula help
Thank you so much for your help!
i actually needed to total the columns. I rec'd my anser from another post "Don Guillett" wrote: You probably meant =if(a2=D2,b2+c2,"") -- Don Guillett Microsoft MVP Excel SalesAid Software "Araseli" wrote in message news hello, I have A B C B E 1 c 100 90 c 2 c 100 100 b 3 d 200 80 f 4 d 100 90 d total I need a formula that will add column B and column C only if columns A & B are the same. Thanks! |
#5
|
|||
|
|||
formula help
I actually used the one for the whole table and that worked!
Thank you sooo much! I have another Q: If i need to have a count for the columns where A & D are the same which formula should is use? "JBeaucaire" wrote: I wasn't sure if you're asking for one global answer, or line by line calculations, so here's both. To get row 1 to do a simple test, put this in E1 and copy down: =IF(A1=D1,B1+C1) To get one answer for the whole table in one cell without the formula above helping, put this formula down below somewhe =SUMPRODUCT((A1:A4=D14)*(B1:B4+C1:C4)) Expand the ranges as needed, but make sure they're all the same size. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Araseli" wrote: hello, I have A B C D E 1 c 100 90 c 2 c 100 100 b 3 d 200 80 f 4 d 100 90 d total I need a formula that will add column B and column C only if columns A & B are the same. Thanks! |
#6
|
|||
|
|||
formula help
Perhaps:
=COUNTIF($A$1:$A$100,$D$1:$D$100) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Araseli" wrote: I actually used the one for the whole table and that worked! Thank you sooo much! I have another Q: If i need to have a count for the columns where A & D are the same which formula should is use? "JBeaucaire" wrote: I wasn't sure if you're asking for one global answer, or line by line calculations, so here's both. To get row 1 to do a simple test, put this in E1 and copy down: =IF(A1=D1,B1+C1) To get one answer for the whole table in one cell without the formula above helping, put this formula down below somewhe =SUMPRODUCT((A1:A4=D14)*(B1:B4+C1:C4)) Expand the ranges as needed, but make sure they're all the same size. -- |
Thread Tools | |
Display Modes | |
|
|