Sunday, May 7, 2017

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!!!



Kenneth