Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum.If function but depending on 3 different columns?
I hope someone can help me out he
I have 2 worksheets: WS1 WS2 On WS2 I need to sum all values of column D on WS1 that have: WS1 column A = 1 WS1 column B = 3 WS1 column C <= 7 Is this possible and if yes, how can I accomplish this? Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum.If function but depending on 3 different columns?
=SUMPRODUCT(--(A2:A200=1),--(B2:B200=3),--(C2:C200<=7),D2:D200)
-- Regards, Peo Sjoblom "corne_mo" wrote in message ... I hope someone can help me out he I have 2 worksheets: WS1 WS2 On WS2 I need to sum all values of column D on WS1 that have: WS1 column A = 1 WS1 column B = 3 WS1 column C <= 7 Is this possible and if yes, how can I accomplish this? Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum.If function but depending on 3 different columns?
Hi Peo,
just did a very small test and it looks like it works although the sumproduct function isn't made for this purpose as far as I know. Can you explain me the function you give above, including the -- part? Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum.If function but depending on 3 different columns?
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
-- Regards, Peo Sjoblom "corne_mo" wrote in message ... Hi Peo, just did a very small test and it looks like it works although the sumproduct function isn't made for this purpose as far as I know. Can you explain me the function you give above, including the -- part? Thanks in advance. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum.If function but depending on 3 different columns?
Many thanks ! :-))
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum.If function but depending on 3 different columns?
Thanks for the feedback
-- Regards, Peo Sjoblom "corne_mo" wrote in message ... Many thanks ! :-)) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum.If function but depending on 3 different columns?
Still one questions though:
I tried this over multiple worksheets, where the table is on worksheet1 and the formula in worksheet 2: =SUMPRODUCT(--(WS1!A1:A14=1);--(WS1!B:B="b");--(WS!C:C<9);WS1!D1:D14) The following statements give errors: --(WS1!B:B="b") --(WS!C:C<9) What am I doing wrong here? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function to count the amount of cells depending on part of the cell entry | Excel Worksheet Functions | |||
Function or number depending on input | Excel Worksheet Functions | |||
Help with function to sum values in a worksheet depending on account number | Excel Worksheet Functions | |||
min function from different columns | Excel Worksheet Functions | |||
changing a cell value depending on an If Function/Lookup | Excel Worksheet Functions |