LANG SELRCT

Apps Script Reference  (Create: Create new Spreadsheet | Create new Apps Script

Saturday, December 15, 2018

COUNTIFSを使ってみる


countifを組み合わせたいときに使うcountifsの備忘録

例えばこういう表があって
F2に
=countifs(B:B,$F$1,C:C,E2)
のように書くと
B列がTODOでC列がTODAYの件数を出せます

上のシートではFGH列には以下のような関数を入れています
TODODOINGDONE
TODAY=countifs(B:B,$F$1,C:C,E2)=countifs(B:B,$G$1,C:C,E2)=countifs(B:B,$H$1,C:C,E2)
TOMORROW=countifs(B:B,$F$1,C:C,E3)=countifs(B:B,$G$1,C:C,E3)=countifs(B:B,$H$1,C:C,E3)


コピペで試す用の表
ITEM1TODOTOMORROWTODODOINGDONE
ITEM2DOINGTODAYTODAY


ITEM3DONETODAYTOMORROW


ITEM4TODOTOMORROW
ITEM5TODOTOMORROW
ITEM6TODOTOMORROW
ITEM7DOINGTODAY
ITEM8DONETODAY
ITEM9DONETOMORROW
ITEM10DONETOMORROW
ITEM11TODOTOMORROW
ITEM12DOINGTOMORROW


Latest post

Extracting data from Google Sheets with regular expressions

Introduction Regular expressions are a powerful tool that can be used to extract data from text.  In Google Sheets, regular expressions ca...