yogi_Compute Weekly Stats From Hourly And Daily Data

Google Spreadsheet   Post  #2157

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-07-2017

question by KM1388:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/MA6PvQQSGLU;context-place=mydiscussions
Need help on sum and count formula please.
Hi all,

I need some help on sum and count formula for a simple calculation.

=Query(Hours!A:G,"Select A,B, MAX(C),SUM(E),SUM(F), 3*(COUNT(D)+COUNT(F))+sum(G) where A is not null group by A,B",1)

on the formula i use 3*(COUNT(D)+COUNT(F))+sum(G) the result came out null value, if the column G value is null value. you could compare the output on column F and column H with the share link below:

can anyone help please!!!

https://docs.google.com/spreadsheets/d/1ySwvoKx-8WOkc09DGckpaWE_9D_Rp3OPpYzmbKLK0Zw/edit#gid=669098519

Kenneth