How to get a formula to calculate only if a certain condition is met on another sheet

**necht_angel** · 03-08-2012, 04:33 AM

Hi there,

I have a formula that I want to calculate only if a certain condition is met on another sheet. I have attached an example with notes, which will hopefully explain in more detail what I am trying to do. Im thinking something to do with SUMIF, but any way I have tried it I am getting error messages, so I thought rather than throw my laptop out of the window in complete frustration, I would ask someone better qualified than I.

Thanks for looking, and thanks for any help you can give me, much appreciated.

Kate :-)

**Bob Phillips** · 03-08-2012, 04:54 AM

What do you want the cells to show if the condition is not met?

**necht_angel** · 03-08-2012, 05:00 AM

If the condition is not met I want it to return "0"

**kvsrinivasamurthy** · 03-08-2012, 05:02 AM

Ty this in H2 cell of sheet2.

=IF(Sheet1!C2=1,SUM(H3:I4)*$D$5,0)

**necht_angel** · 03-08-2012, 05:09 AM

Thanks so much , that worked a treat. :-)

Kate

How to get a formula to calculate only if a certain condition is met on another sheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to get a formula to calculate only if a certain condition is met on another sheet

Re: How to get a formula to calculate only if a certain condition is met on another sheet

Re: How to get a formula to calculate only if a certain condition is met on another sheet

Re: How to get a formula to calculate only if a certain condition is met on another sheet

Re: How to get a formula to calculate only if a certain condition is met on another sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions