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.
Trending News
the function COUNTIF() in MS Excel?
In MS Excel, the function COUNTIF() works on range of data, ie data has to be contiguous. Is there any similar function that works on non-contiguous data?
2 Answers
- 1 decade agoFavorite Answer
You can simply add multiple COUNTIFs together for each non-contiguous range. ie: countif(a1..c12,"cond") + countif(d4..f16,"cond") + ...
Hope this helps
- Anonymous1 decade ago
You have to be sorting on something within this excel file in order for a count of something. If you are you could try using Sub-Totals. You can count anything as long as the field is not blank.
