Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement
I'm trying to create a formula for the following:
If C3 - C2233 = WW and If AA3 - AA2233 = 1 than add column EW3 - EW 2233 Can someone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement
try
=if(and(C3-C2233=WW,AA3-AA2233=1),Sum(EW3:EW2233),"otherwise") unless you mean to only add the values in Column EW when the values in column C and column AA are appropriate in this case try =sumproduct(--(C3:C2233=WW),--(AA3:AA2233=1),EW3:EW2233) "Karen Smith" wrote: I'm trying to create a formula for the following: If C3 - C2233 = WW and If AA3 - AA2233 = 1 than add column EW3 - EW 2233 Can someone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement
I am only adding the values in Column EW when the values in column C and
column AA are appropriate. Here's the formula I used, but my answer = 0 and it should have a number in it. What am I doing wrong? =SUMPRODUCT(--('Master List'!$C$3:$C$2233="ag"),--('Master List'!$AA$3:$AA$2233="1"),'Master List'!$EW$3:$EW$2233) "bj" wrote: try =if(and(C3-C2233=WW,AA3-AA2233=1),Sum(EW3:EW2233),"otherwise") unless you mean to only add the values in Column EW when the values in column C and column AA are appropriate in this case try =sumproduct(--(C3:C2233=WW),--(AA3:AA2233=1),EW3:EW2233) "Karen Smith" wrote: I'm trying to create a formula for the following: If C3 - C2233 = WW and If AA3 - AA2233 = 1 than add column EW3 - EW 2233 Can someone help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement
several possibilities
the most probables are 1 the value in column AA is actually a number in which case you should get rid of the quote marks around 1 and use =SUMPRODUCT(--('Master List'!$C$3:$C$2233="ag"),--('Master List'!$AA$3:$AA$2233=1),'Master List'!$EW$3:$EW$2233) 2 there could be leading spaces in column Column C use the trim() function ....trim(C3:C2233... "Karen Smith" wrote: I am only adding the values in Column EW when the values in column C and column AA are appropriate. Here's the formula I used, but my answer = 0 and it should have a number in it. What am I doing wrong? =SUMPRODUCT(--('Master List'!$C$3:$C$2233="ag"),--('Master List'!$AA$3:$AA$2233="1"),'Master List'!$EW$3:$EW$2233) "bj" wrote: try =if(and(C3-C2233=WW,AA3-AA2233=1),Sum(EW3:EW2233),"otherwise") unless you mean to only add the values in Column EW when the values in column C and column AA are appropriate in this case try =sumproduct(--(C3:C2233=WW),--(AA3:AA2233=1),EW3:EW2233) "Karen Smith" wrote: I'm trying to create a formula for the following: If C3 - C2233 = WW and If AA3 - AA2233 = 1 than add column EW3 - EW 2233 Can someone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) |