To count try

'Weeks as text
=SUMPRODUCT((A2:A100="Sunday")*(B2:B100<""))

'Col A contains dates formatted as weekdays
=SUMPRODUCT((WEEKDAY(A2:A100)=1)*(B2:B100<""))



If this post helps click Yes
---------------
Jacob Skaria


"LQQKB4uleep" wrote:

None of these suggestions worked, any other ideas please...anyone?

"LQQKB4uleep" wrote:

Column A has Days of the week listed for the entire month
Column B has data listed for days of the week
Want formula to count data in column B if it equals a certain day of the week

like if sunday then count all data listed for sundays in column B

"a" "B"
Sunday 21
Monday 15
Tuesday 28

Sunday 14
Monday 10
Tuesday 12

sunday=35
Monday=25
Tuesday=40