Calculating a Rate

[datadummy]

I am trying to calculate a rate and am getting a rate of 1200%, so clearly I have a mistake in my equation but can't figure out where. Here is my statement,
=COUNTIFS(ED!F:F,"N",ED!G:G,"Y",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")/COUNTIFS(ED!F:F,"N",ED!G:G,"Y",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")+COUNTIFS(ED!F:F,"N",ED!G:G,"N",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")

I'm sure there is a better way to write this statement and am open to any suggestions! Thanks in advance!!

 

[RedWolf3x]

Plug in =COUNTIFS(ED!F:F,"N",ED!G:G,"N",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018") And I bet you get 11.

You have

COUNTIFS(ED!F:F,"N",ED!G:G,"Y",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")
/
COUNTIFS(ED!F:F,"N",ED!G:G,"Y",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")
+
COUNTIFS(ED!F:F,"N",ED!G:G,"N",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")

COUNTIFS(ED!F:F,"N",ED!G:G,"Y",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")
/
COUNTIFS(ED!F:F,"N",ED!G:G,"Y",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")
Is going to = 1

COUNTIFS(ED!F:F,"N",ED!G:G,"N",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")
Probably = 11

Add them together and you get 12. Format to percent and get 1200%

Unfortunately I'm not sure what you are trying to accomplish, but that is what Excel is doing.

 

[datadummy]

What I am trying to accomplish is to calculate the number or times column F= N and column G=Y and that the date is equal to April hence >3/31/2018 and <5/1/2018. Divided by the totals of columns F and G within the month of April. Currently the results should be 2 out 13 for 15%.

 

[RedWolf3x]

Try

=COUNTIFS(ED!F:F,"N",ED!G:G,"Y",ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")\COUNTIFS(ED!D:D,">3/31/2018",ED!D:D,"<5/1/2018")