formulas in excel that gather info from dates?

Sure,

i dig the circles and arrows :o)

- Sheet2 B3 copy&paste this COUNTIF() formula

=COUNTIF(orders!$F$1:$F$14,A3)

- Sheet C3 you have your choice of the COUNTIFS() formula or a SUMPRODUCT() formula

=SUMPRODUCT((orders!$F$1:$F$14=A3)* (orders!$U$1:$U$14))

- and of course D3 gets this formula

=C3/B3

you can change all the 14 to 9999 to expand the range, just make sure you change all three of the 14s.

you can select all 3 cells, then copy&paste down the columns on sheet 2.

let me know how it works, or if you want the COUNTIFS()

edit-

oops, you dont need a COUNTIFS() at all, you can use a SUMIF()

so you can use these formulas

=COUNTIF(orders!F:F,A3)

and

=SUMIF(orders!F:F,A3, orders!U:U)

you can also make a "pivot table" out of your data.

perfect!!!! thank you very much for that.