Formula Help

[tj123001]

I am trying to get this formula to work.

=IF($B$2="",SUMIFS('Revenue Data'!$E$2:$E$2426,'Revenu
Data'!$N$2:$N$2426,'Total Summary'!$B21,'Revenu
Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenu
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18,'Revenu
Data'!$G$2:$G$2426,'Total Summary'!$B$3),IF($B$3="",SUMIFS('Revenu
Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Tota
Summary'!$B21,'Revenue Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenu
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18,'Revenu
Data'!$F$2:$F$2426,'Total Summary'!$B$2),SUMIFS('Revenu
Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Tota
Summary'!$B21,'Revenue Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenu
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18)))

It is returning an answer of zero which is not correct...I can't figur
out if I need to add and "AND" or an "OR" in here... Any thoughts

 

[tj123001]

I am trying to get this formula to work.

=IF($B$2="",SUMIFS('Revenue Data'!$E$2:$E$2426,'Revenu
Data'!$N$2:$N$2426,'Total Summary'!$B21,'Revenu
Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenu
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18,'Revenu
Data'!$G$2:$G$2426,'Total Summary'!$B$3),IF($B$3="",SUMIFS('Revenu
Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Tota
Summary'!$B21,'Revenue Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenu
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18,'Revenu
Data'!$F$2:$F$2426,'Total Summary'!$B$2),SUMIFS('Revenu
Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Tota
Summary'!$B21,'Revenue Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenu
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18)))

It is returning an answer of zero which is not correct...I can't figur
out if I need to add and "AND" or an "OR" in here... Any thoughts?

Never Mind I figured it out. The order was not allowing the formula t
calculated correctly!! Yea

 

[Stan Brown]

I am trying to get this formula to work.

=IF($B$2="",SUMIFS('Revenue Data'!$E$2:$E$2426,'Revenue
Data'!$N$2:$N$2426,'Total Summary'!$B21,'Revenue
Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenue
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18,'Revenue
Data'!$G$2:$G$2426,'Total Summary'!$B$3),IF($B$3="",SUMIFS('Revenue
Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Total
Summary'!$B21,'Revenue Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenue
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18,'Revenue
Data'!$F$2:$F$2426,'Total Summary'!$B$2),SUMIFS('Revenue
Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Total
Summary'!$B21,'Revenue Data'!$J$2:$J$2426,'Total Summary'!D$19,'Revenue
Data'!$K$2:$K$2426,'Total Summary'!$D$18:$F$18)))

It is returning an answer of zero which is not correct...I can't figure
out if I need to add and "AND" or an "OR" in here... Any thoughts?

Yes, but this is a family newsgroup so I can't write them down.

Seriously, two words: helper cells. When a formula is too complex
for its author to understand, you should break it into sub-formulas
in a couple of cells so that you can figure out what's going on.