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. |
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 |