sum in excel

[accjrf]

i have a spreadsheet that has a column of names and another column of sales $. I am going to add a 3rd column with an identifier for certain rows that I want to exclude in a total at the bottom. how can i write a sum that looks at a different column to know if it should include/exclude the Sales $ in the total?

Name Sales Include
1 10 N
2 15 Y
3 20 Y

I want the total to be 35 at the bottom of the sales column in this example.

 

[dhulbert]

Use SumIf

=SUMIF(Range,"=Y",Sum_Range)



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[accjrf]

I didnt realize such a function existed but that is exactly what i need. Thanks!!

 

[SkipVought]

total at the bottom

You might consider a different 21^st century paradigm.

The "bottom line" is a phrase that is a anachronistic as "dialing" a phone number.

With a tool like a spreadsheet, the "bottom line" does not need to be at the bottom. That used to make sense, when the bookkeeper would tally columns of numbers on multiple sheets using an adding machine and a pencil.

With an advanced tool like Excel, you can put vital summary information for the boss and upper management, right at the very TOP, making it possible to see the "bottom line" without having to scroll and hunt. It makes much more sense to prominently position this précis.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}