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

user Brian Podolak said: (!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.
gets me the sales for the day (s4 is todays date)
I try to complete it like this
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