sumif to pull through from 2 sheets

[zoepryce]

Hi, I'm looking to pull data through to show if the answer is true to show was true but if false to then look at another sheet and then if true on there to return something else instead of true, let's say 'maybe' how do I do this. I've got the formula looking at the first sheet but can't get it look at the second sheet? thanks

 

[awoohaw]

Please share your formulas? Maybe even some sample data and expected results? Please help the forum help you.
Mr. Excel has a tool called xl2bb add in (Link below) that allows you to share mini worksheets.

 

[zoepryce]

Hi, this is the formula it's doing to return TRUE however I only wanted it to do this formula if cell U3 is showing FALSE =SUMIFS('Test'!D:D,'Test'!$B:$B,$B3)>0
Thank you

 

[awoohaw]

Please post a sample of your worksheet using the xl2bb add in?
But, my guess is this
=IF(U3=FALSE,"Do what happens if U3 is FALSE", TRUE)

or maybe just:
if the formula in U3 is this:
SUMIFS('Test'!D:D,'Test'!$B:$B,$B3)>0

This formula may work:
=IF(SUMIFS('Test'!D:D,'Test'!$B:$B,$B3)>0,"Do what happens when this is true",TRUE)

or maybe that is what you want to do when U3 is false, then do this:

=IF(U3=FALSE,SUMIFS('Test'!D:D,'Test'!$B:$B,$B3)>0,TRUE)