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!

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!

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!