Excel help please!
 

I'm not sure if this is possible. I've searched the books & online and can't
find my answer so here I am...
Here's the worksheet I have
Column A Column B Column C
Book P 55
Singing S 2
Program Y 18

What I want to happen is ..(I'm looking for the correct formula) ... if
column B is "P" then I want to sum up the corresponding cells in Column C.
Make sense? Please help .. I'm about to pull my hair out!

Excel help please!
 

One way is =SUMIF(B1:B3,"p",C1:C3)
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"smannes" wrote:

I'm not sure if this is possible. I've searched the books & online and can't
find my answer so here I am...
Here's the worksheet I have
Column A Column B Column C
Book P 55
Singing S 2
Program Y 18

What I want to happen is ..(I'm looking for the correct formula) ... if
column B is "P" then I want to sum up the corresponding cells in Column C.
Make sense? Please help .. I'm about to pull my hair out!

Excel help please!
 

THANK YOU THANK YOU THANK YOU!!! You're a life saver!

"John" wrote:

One way is =SUMIF(B1:B3,"p",C1:C3)
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"smannes" wrote:

I'm not sure if this is possible. I've searched the books & online and can't
find my answer so here I am...
Here's the worksheet I have
Column A Column B Column C
Book P 55
Singing S 2
Program Y 18

What I want to happen is ..(I'm looking for the correct formula) ... if
column B is "P" then I want to sum up the corresponding cells in Column C.
Make sense? Please help .. I'm about to pull my hair out!