Hi,
be careful the range has to be the same in both part of the formulas
I know the formula works I checked
I you don't find the error please post the formula you are using again ,
thanks

"Eduardo" wrote:

Hi,
which result do you get, the name in column c for my formula has to be
exactly the same as column A, if you typed the name in column C check for
blank spaces in column A. or take the names from column A and copy into C

"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