What does the following do?
=SUMIFS([DAY]:[DAY],[AIR]:[AIR],"<>")
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
