skip to main
|
skip to sidebar
Simple life, Complicated mind
Wednesday, August 3, 2016
sum up group by criteria in Google Sheets
=sum(sumif(indirect(C4&"!$A$2:A"), A4, indirect(C4&"!$F$2:F"))*24)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Total Pageviews
Search This Blog
About Me
https://github.com/junxie6
https://stackoverflow.com/users/409319/jun-xie
https://blog.ijun.org/
Recommended Articles
Install Vue
CentOS and Red Hat 7: Install Linux, Apache MPM, MariaDB, PHP (LAMP) Stack
Install MySQL 5.7, Apache 2.4, PHP 7.1 on Ubuntu 16.04
Labels
Amazon Web Services
(9)
Android
(2)
AngularJS
(2)
Apache
(72)
Arduino
(1)
Assembly
(19)
Backup
(39)
Bash
(8)
Batch
(14)
Big Data
(1)
Book
(1)
Business Terminology
(9)
C
(58)
C# .NET
(71)
command
(71)
Computer Terminology
(27)
Data
(1)
Data mining
(1)
Debian
(1)
Debugging
(52)
Django
(7)
DNS
(5)
Docker
(12)
Drupal
(125)
Drupal 8
(12)
Elasticsearch
(1)
English Vocabulary
(56)
ERP
(3)
Excel
(4)
Exchange Server
(41)
FFmpeg
(4)
Financial Management
(1)
FreeBSD
(270)
Game
(1)
Git
(8)
golang
(53)
Golden Saying Quotation
(77)
Good Articles
(143)
Google Sheets
(1)
Hardware
(5)
Health
(8)
HTML/CSS
(46)
HTML5
(3)
IIS
(14)
ImageMagick
(3)
Internet of Things (IoT)
(3)
iPhone
(2)
Issue Tracker
(2)
IT Talk
(4)
Java
(1)
JavaScript
(79)
jQuery
(61)
jQWidgets
(2)
Linux
(111)
Load Balancing
(19)
Mac OS X
(15)
Magento
(70)
Magento 2
(13)
Mail
(17)
Math
(4)
Miscellaneous (Others)
(30)
Money
(11)
MongoDB
(2)
MySQL
(172)
Network
(13)
News
(4)
Nginx
(16)
Node.js
(3)
Performance
(31)
Perl
(12)
pfSense
(7)
PHP
(183)
PhpStorm
(3)
PHPUnit
(2)
Postfix
(3)
PostgreSQL
(2)
PowerShell
(5)
PrestaShop
(2)
Printer
(5)
Programming Talk
(153)
Prometheus
(1)
Proxy
(9)
Python
(19)
Raspberry PI
(4)
Redis
(3)
Redundancy
(8)
Regular Expression
(16)
Restaurant
(1)
Reverse Engineering
(1)
Revision Control
(32)
RouterOS
(1)
Ruby
(3)
Script
(8)
Security
(15)
Software Quality Assurance and Testing
(22)
SQL Injection
(11)
SQL Server
(77)
SSH
(5)
Storage
(3)
Symfony
(25)
tmp
(31)
ToDo
(181)
Tools
(156)
Two-factor Authentication
(3)
Ubuntu
(25)
Unicode
(32)
Unix-like Tips
(88)
VB .NET
(4)
VBScript
(66)
Video conferencing
(2)
vim
(100)
VirtualBox
(2)
Virtualization
(8)
VMware
(21)
VoIP
(1)
VPN
(14)
Vue
(3)
Web Development
(6)
Windows API
(1)
Windows MIS
(127)
Windows Mobile
(4)
WPF
(1)
X Window
(2)
Xen
(2)
XML
(6)
Zend Studio
(1)
Blog Archive
►
2019
(5)
►
February
(2)
►
January
(3)
►
2018
(50)
►
November
(2)
►
October
(5)
►
September
(13)
►
August
(3)
►
July
(2)
►
June
(1)
►
May
(6)
►
February
(8)
►
January
(10)
►
2017
(94)
►
December
(19)
►
November
(2)
►
October
(11)
►
September
(11)
►
July
(4)
►
June
(1)
►
May
(5)
►
April
(6)
►
March
(4)
►
February
(25)
►
January
(6)
▼
2016
(196)
►
December
(10)
►
November
(11)
►
October
(17)
►
September
(5)
▼
August
(3)
How to prevent or disable favicon.ico requests?
C# .Net monitor directory file changed created
sum up group by criteria in Google Sheets
►
July
(9)
►
June
(15)
►
May
(14)
►
April
(35)
►
March
(49)
►
February
(10)
►
January
(18)
►
2015
(307)
►
December
(26)
►
November
(24)
►
October
(9)
►
September
(23)
►
August
(19)
►
July
(34)
►
June
(12)
►
May
(6)
►
April
(27)
►
March
(35)
►
February
(61)
►
January
(31)
►
2014
(220)
►
December
(23)
►
November
(53)
►
October
(4)
►
September
(7)
►
August
(17)
►
July
(35)
►
June
(18)
►
May
(2)
►
April
(20)
►
March
(10)
►
February
(20)
►
January
(11)
►
2013
(163)
►
December
(6)
►
November
(12)
►
October
(12)
►
September
(27)
►
August
(18)
►
July
(15)
►
June
(18)
►
May
(29)
►
April
(19)
►
March
(1)
►
January
(6)
►
2012
(132)
►
December
(23)
►
November
(11)
►
October
(6)
►
September
(2)
►
August
(1)
►
July
(5)
►
June
(13)
►
May
(16)
►
April
(8)
►
March
(7)
►
February
(9)
►
January
(31)
►
2011
(236)
►
December
(51)
►
November
(38)
►
October
(27)
►
September
(34)
►
August
(5)
►
July
(8)
►
June
(6)
►
May
(14)
►
April
(4)
►
March
(19)
►
February
(6)
►
January
(24)
►
2010
(259)
►
December
(56)
►
November
(43)
►
October
(6)
►
September
(7)
►
August
(18)
►
July
(39)
►
June
(12)
►
May
(25)
►
April
(12)
►
March
(14)
►
February
(9)
►
January
(18)
►
2009
(742)
►
December
(58)
►
November
(143)
►
October
(55)
►
September
(48)
►
August
(35)
►
July
(31)
►
June
(40)
►
May
(25)
►
April
(95)
►
March
(99)
►
February
(42)
►
January
(71)
►
2008
(273)
►
December
(70)
►
November
(71)
►
October
(68)
►
September
(54)
►
August
(2)
►
July
(7)
►
June
(1)
Popular Posts
程式設計師不可不注意的五件事
Get product tier pricing programmatically in Magento 2
別忘了人生另外三分之二的風景
頭腦裡的開關
gpg: agent_genkey failed: Permission denied
Volume Shadow Copy Failed to create the storage area association
Squid transparent SSL proxy on pfSense
CentOS and Red Hat 7: Install Linux, Apache MPM, MariaDB, PHP (LAMP) Stack
Install MySQL 5.7, Apache 2.4, PHP 7.1 on Ubuntu 16.04
玩股網
Recommend Sites
fcamel 技術隨手記
fcamel's blog
FourDollars Blog
Fred's Blog
Gea-Suan Lin's BLOG
SCRATCHING MY NEEDS
Think Exist
Thinker
一又@CROSS [ SSORC.tw ]
小惡魔 AppleBOY
Joey
No comments:
Post a Comment