Google Spreadsheet Post #1386
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct 07, 2013
user: Rosa Crisostomo (http://productforums.google.com/forum/?zx=6ycrwucpw4f9#!category-topic/docs/spreadsheets/vMMstzoCdEY)
Return a count of records between specified dates for each speaker
On worksheet 'Speaker Totals' I need to calculate how many orders per quarter (first example: July - Sept) each speaker sold. All this data is listed on worksheet 'Event Data'.
Column A = Dates
Column C = Speaker
Column H = Total Orders
I would normally use sumifs but google docs does not allow this function.
I am using Windows 7
--------------------------------------------------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct 07, 2013
user: Rosa Crisostomo (http://productforums.google.com/forum/?zx=6ycrwucpw4f9#!category-topic/docs/spreadsheets/vMMstzoCdEY)
Return a count of records between specified dates for each speaker
On worksheet 'Speaker Totals' I need to calculate how many orders per quarter (first example: July - Sept) each speaker sold. All this data is listed on worksheet 'Event Data'.
Column A = Dates
Column C = Speaker
Column H = Total Orders
I would normally use sumifs but google docs does not allow this function.
I am using Windows 7
--------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment