Help us understand the problem. What is going on with this article?

COUNTIF文、SUMIF文

データを条件指定で数える

・B列が0のものを数える場合
=countif(B:B,"=0")

・B列が1以上、2000未満の場合
=countifs(B:B,">=1",B:B,"<2000")

データを条件指定で合計する

・C列の数値を合計したい、B列が0の場合
=sumif(B:B,"=0",C:C)

・C列の数値を合計したい、B列が1以上、2000未満の場合
=sumifs(C:C,B:B,">=1",B:B,"<2000")

データが追加される可能性がある場合
例)B列 B:B

shiori03
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away