Hi,

you could create a pivot table. Drag Days to the row area and numbers to
the data area. Right click any number in the data area and select value
field settigns. Change the "Summarise by" field from sum to count.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LQQKB4uleep" wrote in message
...
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