Friday, September 28, 2012

yogi_Compute Number Of Sales By Salesmen On A Specified Date In Another Sheet

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #781  Sep 28, 2012    www.energyefficientbuild.com.

user Brian Podolak said: (http://productforums.google.com/forum/?zx=357yj7i8jxeu#!category-topic/docs/spreadsheets/N35AHazUJ6k)
COUNTIF or SUM? Im so confused.
Basically I have a workbook with 2 sheets

SHEET1 has data in it like this

A                                                     B
9/7/2012 13:14:00                          Brian
9/10/2012 10:19:00                        Bob

On Worksheet SHEET2
I want to total the occurrences of Brian and Bob based on a date I have in C7
So this way I can see

Brian  1
Bob     1

I use this sheet to tracks sales by my sales reps.
=ArrayFormula(countif(INT(SHEET1!A:A),S4))  
gets me the sales for the day (s4 is todays date)
I try to complete it like this
=ArrayFormula(sum((INT(SHEET1!A:A),S4))*(countif(SHEET1!F:F,J10)))
Where F is the reps name
and crash and burn.
No hurry, but I am on a step ladder with a towel around my neck. I am sure will be something simple.
Thanks in advance gang!

------------------------------------------------------------------------------
following is a solution to the problem as best I understand your question

1 comment: