"Metolius Dad" wrote in message
...
Column A has dates in the year. Col B has customers on that date. What
formula can I use to find the total number of customers on all the
Tuesdays?
Average number for each Tuesday?
TIA, I appreciate you folks being there.
Sam Beardsley
One way
In Column C, enter =WEEKDAY(A1)
To get the total number of customers for a Tuesday, enter =COUNTIF(A1:A23,"=
3")
Of course, you need to adjust the range.
/Fredrik
|