Formula to reference a cell

**stu00** · 07-26-2009, 11:14 AM

Hello,

I am trying to create a formula in Excel to preform a "SUM" on cells that only have a letter Y (as in "yes") in the cell next to them.

For example

Please Login or Register  to view this content.

I want the output of this to be 25.50 (hence the two cells with the "Y" next to them and the cell with the "N" is ignored.

Thank you for the help.

Stu00

**arthurbr** · 07-26-2009, 11:16 AM

Hi and welcome to the board

Have a look at the SUMIF function

**stu00** · 07-26-2009, 11:20 AM

Thanking you most kindly.

**arthurbr** · 07-26-2009, 03:12 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save