sumifs

What does the following do?

=SUMIFS([DAY]:[DAY],[AIR]:[AIR],"<>")

Thanks,

Tom

>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])