need help writing function
In c1 put:
=SUMIF(A:A,A1,B:B)
Change the "A1" part to match the day you want to total.
Squeaky
"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
|