On Fri, 15 Feb 2013 05:31:43 +0000, tj123001 wrote:

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.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...