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
|
|||
|
|||
calculated celles according to more then 1 condition
Col B = name (text field)
Col C = Last name (text field) Col D = Expences (number) I would like to SUM to A1 total expences of a person (True on 2 conditions on Col B & Col C) Name will apear more then once on A & B Thanks a milion |
#2
|
|||
|
|||
calculated celles according to more then 1 condition
Hi
=SUMPRODUCT((A1:A20=D1)*(B1:B20=D2)*(C1:C20)) Where D1 & D2 are the names you want to sum by. Mike "-yuval" wrote: Col B = name (text field) Col C = Last name (text field) Col D = Expences (number) I would like to SUM to A1 total expences of a person (True on 2 conditions on Col B & Col C) Name will apear more then once on A & B Thanks a milion |
#3
|
|||
|
|||
calculated celles according to more then 1 condition
Hi
Try this array formula, press Ctrl,Shift and Enter together after placing the formula in A2 =SUM(IF($B$2:$B$20=E2,IF($C$2:$C$20=F2,$D$2:$D$20, 0),0)) where E2 and F2 is where you type the name and last name into or another non array formula, =SUMPRODUCT(--(B2:B20=E2),--(C2:C20=F2),D220) where E2 and F2 are where you type in the name and last name Hope these will do what you want. -- Pls provide your feedback by clicking the Yes button below if this post have help you. This will help others to search the archives for result better. Thank You cheers, francis "-yuval" wrote: Col B = name (text field) Col C = Last name (text field) Col D = Expences (number) I would like to SUM to A1 total expences of a person (True on 2 conditions on Col B & Col C) Name will apear more then once on A & B Thanks a milion |
#4
|
|||
|
|||
calculated celles according to more then 1 condition
Thanks a milion
It just worked perfect for what I needed. Bravo !!! -yuval |
#5
|
|||
|
|||
calculated celles according to more then 1 condition
Thank you very much it worked perfect for what I needed.
Bravo !!! -yuval |
#6
|
|||
|
|||
calculated celles according to more then 1 condition
Thank you for the feedback. Am glad that this works for you
-- Pls provide your feedback by clicking the Yes button below if this post is helpful to you. This will help others to search the archives for result better. Thank You cheers, francis "-yuval" wrote: Thanks a milion It just worked perfect for what I needed. Bravo !!! -yuval |
Thread Tools | |
Display Modes | |
|
|