Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and
I want to sum amounts from one column if 2 other columns meet the criteria I
defined. Here is what I have: =IF(AND(A:A="x",B:B=""),SUM(C:C)) Even though I have a lot of rows that match both criteria (have an "x" in column A and nothing in column B), the formula returns "false". Any ideas? Thanks! |