sumifs

T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top