Thread
:
sum values in cell based on another cell
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
external usenet poster
Posts: 3,440
sum values in cell based on another cell
Hi Brandon,
=SUMIF(D1:D4,"Monday",A1:A4)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"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:
Reply With Quote
Niek Otten
View Public Profile
Find all posts by Niek Otten