sum values in cell based on another cell

B

Brandon P

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:
 
N

Niek Otten

Hi Brandon,

=SUMIF(D1:D4,"Monday",A1:A4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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:
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top