Help using an IF function across multiple tabs.

[braderz]

Hi everyone,

First time poster to the forum.
What I'm looking to do is to use an IF function on a master sheet which takes data from multiple tabs. What I have attempted is the following and works for one tab:

=IF('J BLOGGS'!B11="COMPLETED", 'J BLOGGS'!B1, "")

Then if I extend it to multiple tabs this doesn't work:

=IF('J BLOGGS'!B11="COMPLETED", 'J BLOGGS'!B1, "")+IF('M BEAN'!B11="COMPLETED",'M BEAN'!, B1, "")

I plan to extend this further to more tabs so that if this holds there email addresses will appear on the master sheet. Configuring these is another problem in its self as there may be quite a few but I will cross that bridge when it comes to it!

Many thanks in advance any help is much appreciated

 

[oldbrewer]

you can't have +if

try andif

 

[oldbrewer]

sorry I meant IF(AND(............

 

[braderz]

sorry I meant IF(AND(............

That doesn't work unfortunately, im looking for something that works like + does in a COUNTIF FORMULA?

 

[Laavanya]

Hi everyone,

First time poster to the forum.
What I'm looking to do is to use an IF function on a master sheet which takes data from multiple tabs. What I have attempted is the following and works for one tab:

=IF('J BLOGGS'!B11="COMPLETED", 'J BLOGGS'!B1, "")

Then if I extend it to multiple tabs this doesn't work:

=IF('J BLOGGS'!B11="COMPLETED", 'J BLOGGS'!B1, "")+IF('M BEAN'!B11="COMPLETED",'M BEAN'!, B1, "")

I plan to extend this further to more tabs so that if this holds there email addresses will appear on the master sheet. Configuring these is another problem in its self as there may be quite a few but I will cross that bridge when it comes to it!

Many thanks in advance any help is much appreciated

Try this

=concatenate(if('J BLOGGS'!B11="COMPLETED",'J BLOGGS'!B1,"")," ",IF('M BEAN'!B11="COMPLETED",'M BEAN'!B1,""))

You had committed a syntax error also - 'M BEAN'!,B1 should be 'M BEAN'!B1 (no comma between 'M BEAN'! and B1)

 

[braderz]

Try this

=concatenate(if('J BLOGGS'!B11="COMPLETED",'J BLOGGS'!B1,"")," ",IF('M BEAN'!B11="COMPLETED",'M BEAN'!B1,""))

You had committed a syntax error also - 'M BEAN'!,B1 should be 'M BEAN'!B1 (no comma between 'M BEAN'! and B1)

Fantastic Just what I wanted really appreciate that!