Monday, October 7, 2013

yogi_Sum Up Total Sales By Speaker For Specified Quarter (or for all quarters)

                                          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

--------------------------------------------------------------------------------------------------------------------------------------------------