T T. Valko Dec 10, 2009 #2 What does the following do? =SUMIFS([DAY]:[DAY],[AIR]:[AIR],"<>") Click to expand... I never use that syntax so I'm not 100% sure of all its nuances, but in general: It's summing cells in the column named DAY in a table if the corresponding cells in the column named AIR aren't empty cells. Typically, the syntax would be like this: =SUMIFS(Table_name[DAY],Table_name[AIR],"<>") Also, since there is only a single criteria there's really no reason to use the SUMIFS function. SUMIF will do the same thing: =SUMIF(Table_name[AIR],"<>",Table_name[DAY]) -- Biff Microsoft Excel MVP tshad said: What does the following do? =SUMIFS([DAY]:[DAY],[AIR]:[AIR],"<>") Thanks, Tom Click to expand...
What does the following do? =SUMIFS([DAY]:[DAY],[AIR]:[AIR],"<>") Click to expand... I never use that syntax so I'm not 100% sure of all its nuances, but in general: It's summing cells in the column named DAY in a table if the corresponding cells in the column named AIR aren't empty cells. Typically, the syntax would be like this: =SUMIFS(Table_name[DAY],Table_name[AIR],"<>") Also, since there is only a single criteria there's really no reason to use the SUMIFS function. SUMIF will do the same thing: =SUMIF(Table_name[AIR],"<>",Table_name[DAY]) -- Biff Microsoft Excel MVP tshad said: What does the following do? =SUMIFS([DAY]:[DAY],[AIR]:[AIR],"<>") Thanks, Tom Click to expand...
