Formula Help
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?
|