Decimal not displaying as desired

[JOB Dave]

I have solar panels on the house and am running a spread sheet on various totals. What I want to do is get an average monthly production number with 2 decimal places and what I get is 1 or 14 and using the following formula:

=SUMIF(B307:B336,">0")/COUNTA(B307:B336)&" kWh"

I have the Format Cells | Number set to two and the Sample doesn't even change. I've tried adding a ROUND command and changing the decimal from withing the formula with no luck. If I leave it at 0 I get 1 decimal place, any other number I get the 14.

=ROUND(SUMIF(B337:B367,">0"),0)/COUNTA(B337:B367)&" kWh
---------------------------------------^

At the top of the sheet I have yearly totals and an average daily output and they work fine. I'd attach the file but I don't think I'm authorized. I have upgraded to Office 2016.
~Dave

[joeu2004]

What I want to do is get an average monthly production number with 2 decimal places and what I get is 1 or 14 and using the following formula:
=SUMIF(B307:B336,">0")/COUNTA(B307:B336)&" kWh"

=TEXT(SUMIF(B307:B336,">0")/COUNTA(B307:B336),"0.00") &" kWh"

I have the Format Cells | Number set to two

Numeric formats apply only to numeric values. Your formula returns text. We can enter text into a cell that has a numeric format. The type of the cell value is still text.

PS: If you are saving the file as something other than "xls" (Excel 2003 compatible), perhaps the following does what you want:

=TEXT(AVERAGEIF(B307:B336,">0"),"0.00") &" kWh"

Both formulas assume that there is at least one value greater than zero. Otherwise, use IFERROR to avoid a #DIV/0 error.

[joeu2004]

=TEXT(SUMIF(B307:B336,">0")/COUNTA(B307:B336),2) &" kWh"

Doh! That should be:

=TEXT(SUMIF(B307:B336,">0")/COUNTA(B307:B336),"0.00") &" kWh"

(Corrected the original.)

[JOB Dave]

Doh! That should be:

=TEXT(SUMIF(B307:B336,">0")/COUNTA(B307:B336),"0.00") &" kWh"

(Corrected the original.)

That seems to work just fine, Thanks.