1st, I would like to count the quantity a number will occur in D, E & F
independantly of each other based on the day of the week in A.

2nd, Range of numbers in D, E, & F is 0 thru 9.

3rd, in my mind, A "Macro" resides in a tiny little cell, does it's job
with minimal to no further thought on my behalf. "VBA Code" is a bit more
complex and requires a secondary program to write and requires manual
(push a button) effort to execute on a given day.

4th, the Countif doesn't do the job because it only looks at a single
range. The
=SUMPRODUCT(--(A$2:$A$3000="Sun"),--($D$2:$D$3000=1))
doesnt work, I already tried it and it is obviously NOT counting the
correct information. Currently, there is 2859 lines, the net sum of 0 thru
9 is resulting in net totals ranging from 408 to 3080 (net total should be
2859).