=SUMPRODUCT(A2:A5,--(D2:D5="Monday")) or
=SUMPRODUCT((A2:A5)*(D2:D5="Monday"))
--
David Biddulph

"Brandon P" <Brandon wrote in message
...
I tried to find a solution by searching posts, but had no luck
understanding
them. Here is sample table and then my question:

A B C D
0 1 1 Tuesday
0 0 0 Monday
1 0 1 Monday
0 1 0 Friday

I want to add the values in column A where column D="Monday"

I am guessing it would be similar when counting the number of "1"s in
column
A when D="Monday

Any help with this would be greatly appreciated.

:Brandon: