Wednesday, August 13, 2014

yogi_Count Number Of Calls By WeekNumber From Dates In Column F

                        Google Spreadsheet   Post  #1726
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-11-2014
post by Selzzio:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/Xg96HHxUEXY)
Need help determining number of calls for a given week based on a date field
I've searched and searched but can't seem to find the answer so I'm hoping that the group will have some input here.  

I have a Google spreadsheet (http://bit.ly/1sDkRJN) that I need to use to determine how many phone calls are received during a given week.  I've tried COUNTIF and QUERY but am not getting what I seem to need.

I can't add another column for WEEKNUM to the table since the rows are updated from an external process.  Therefore, I need a formula that will calculate it when ever a new row is input into the spreadsheet.

If you look at the spreadsheet you will see what I tried that didn't work:  =countif(A3:F,WEEKNUM(F3:F)=33)

Any and all help would be greatly appreciated.

Thanks,
S
-----------------------------------------------------------------------------------------------------------------------------