Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Lv 42,609 points
GoodMogo
Favorite Answers86%
Answers205
Excel - Using an entire column (instead of individual entries) as the criteria in a SUMIFS function?
Take this formula:
=SUM(SUMIF(C:C,F:F, {"cat","dog"}))
It adds the values in column C that match the values "cat" and "dog" on column F.
I have more than two (cat or dog) values to be evaluated. These values are in a separate column.
How can I avoid entering each item from that column manually as a criteria?
2 AnswersProgramming & Design7 years ago