I'm sorry, but I don't understand your distinction between "ANY" customer
and "total number" of customers.
Could you give an example of your datalist, where that difference would be
evident?
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------
"Metolius Dad" wrote in message
...
Hi RD
This doesn't seem to be working. It DOES count the number of times during
the year that ANY customers were in on a Tuesday but I wanted something that
counted the total number of customers in on all of the Tuesdays.
Thank you
Sam
"Ragdyer" wrote:
Try this for total number of Tuesday customers:
=SUMPRODUCT((WEEKDAY(A1:A365)=3)*(B1:B365<""))
And try this for the average:
=SUMPRODUCT((WEEKDAY(A1:A365)=3)*(B1:B365<""))/SUMPRODUCT(--(WEEKDAY(A1:A36
5)=3))
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"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
|