Combining two IF Functions

I am trying to combine these two if functions, but Excel is saying that there are too many arguments. Does anyone know an easy way to combine them?

First IF:=IF(SUM(COUNTIF('Sheet1'!E:E,"Review Necessary"),COUNTIF('Sheet2'!E:E,"Review Necessary"),COUNTIF('Sheet3'!E:E,"Review Necessary")),BudgetHours,N572)

Second IF: =IF(SUM(COUNTIF('Sheet1'!D:D,0),COUNTIF('Sheet2'!D:D,0),COUNTIF('Sheet3'!D:D,0)),0)

Thanks

Okay...I want to point out something first:

=IF(SUM(COUNTIF(Sheet1!D:D,0),COUNTIF(Sheet2!D:D,0),COUNTIF(Sheet3!D:D,0)),0)

Whatever happens, this formula is always going to be zero...it is zero if TRUE...and it is zero if FALSE. I'm going to speculate this formula was just created to demonstrate what you needed added to the first formula - and it is actually just gibberish by itself .

Here is a combined formula:
=IF(SUM(COUNTIF(Sheet1!E:E,"Review Necessary"),COUNTIF(Sheet2!E:E,"Review Necessary"),COUNTIF(Sheet3!E:E,"Review Necessary"),COUNTIF(Sheet1!D:D,0),COUNTIF(Sheet2!D:D,0),COUNTIF(Sheet3!D:D,0)),BudgetHours,N572)

Final note - All this formula does is set the cell value = BudgetHours IF
a) "Review Necessary" appears anywhere in column E of sheets 1 through 3
OR
b) The value zero appears anywhere in column D of sheets 1 through 3
Otherwise, the value of N572 is inserted.