Help fixing a formula

[datadummy]

I am trying to fix a formula and am not having any luck, here is my current formula that is returning #Div/0!,

=SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,{"Patient is a retired MD, and has a good understanding of his course of care.","No concerns at this time.","Nursing staff is excellent.","Spoke to son as patient has dementia."}))/SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,"?*"))

Not sure where my error is...

 

[Joe4]

You are trying to divide by zero.
So that means that this part is equal to zero in some cases:
SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,"?*"))

So, you can either first check to see if that part is zero like this:
=IF(SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,"?*"))=0,"",SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,{"Patient is a retired MD, and has a good understanding of his course of care.","No concerns at this time.","Nursing staff is excellent.","Spoke to son as patient has dementia."}))/SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,"?*")))

or you can use IFERROR, i.e.
=IFERROR(SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,{"Patient is a retired MD, and has a good understanding of his course of care.","No concerns at this time.","Nursing staff is excellent.","Spoke to son as patient has dementia."}))/SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,"?*")),"")

 

[datadummy]

That worked but now I am being asked to turn the formula around and count column E "Heart Center" subtracted by any text that is in column AV and divide that by Column E "Heart Center". Ay thoughts?

 

[Joe4]

I haven't analyzed your original equation to understand exactly what it is that you are trying to do (and you didn't say what it is actually doing).
But, in the equations I provided, if you need it to return 0 instead of nothing so that it can be used in mathematical equations, then replace the instances of "" with 0.