Question about Haier Chest Freezer HNCM070E

1 Answer

Formula for excel to calculate years of giving.

I have exported information from our database related to giving into excel I need a formula that tells me for AJ2 through BT2 how many cells are not blank. This will let me know the number of years of giving. Thanks for the help.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

In AJ3 thru BT3 put a number. Doesn't matter what number. Then type the following formula into a cell and instead of pressing enter press and hold control, then press and hold shift, and then press enter, and then release all the keys.

=COUNT(IF(NOT(ISBLANK(AJ2:BT2)),AJ3:BT3)



Posted on Aug 05, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

HOW MANY WATTS DOES A 60 LITRE CAMPING FRIDGE USE


That info will be posted on a back plate on the refrigerator.

And if you cannot find anything on the back or inside then hook up ammeter to the unit and measure the amps used after it has been running for about 15 minutes. Then using formula watts = amps times volts (115 in USA) you can arrive at the wattage of unit.

Mar 16, 2015 | Freezers

1 Answer

Freezer light won't come back on .


Is that a florescent bulb in the freezer? Or is there some kind of light bulb in the freezer? If so, change the bulb. I'm not being funny. You give no information on what make, brand and year of the freezer to give you any help.

Apr 07, 2013 | Freezers

1 Answer

What is the normal operational pressure in lo/hi side at the compressor of commercial freezer like dispaly case, reach in cabinet or other any low temp refrigeration uses 502 or408A/404a. is there any rule...


why yes there is. Generally speaking, the head pressure should be around the "ambient +30" rule.
That is, measure the entering air temp to the condenser, say 75 degrees. Now add 30 to that and get 105 degrees. Look at a P/T chart and see what the pressure is for that temp which is about 253 for R-404-A.
The evap on a freezer leads the load so, as a general rule, the evap temp is going to be around minus 10 degrees to get a 0 degree box. Coolers are different. So, the pressure for a minus 10 evap is around 25 or so. But the unit has to be close to operating temp. If the box is warm, naturally the pressure is higher. And what influences the pressure is whether or not it's a TXV or a cap tube system.
If a TXV and no receiver, charge by subcooling. If a receiver, fill by sight glass. If Cap tube, charge by superheat.
Hope that answers your question.

Oct 03, 2010 | True 49 cu. ft. / 1388 liter Commercial...

1 Answer

Have 2 door masterbilt freezer model BLG40HD serial LQ400110. need to know what year manufactured


http://www.master-bilt.com/comdir/direct.htm
go to this site. It has info that you can contact them and just give them your model and serial and they can tell you. It's just that easy.
Hope it helps.

May 29, 2010 | Freezers

1 Answer

Ihave a hoover fridge freezer it started freezing the fridge compartment now freezer not freezing and compressor comes on and go's striaght off again


Sounds like your compressor relay switch is bad but feel the compressor and see if it is hotter then you think it should be. That is easy to tell because you will not want to keep your hand on it long. That would mean a possable bad compressor. Please give a thumbs up for my effort. I could help more if I was there. keep me informed though. The Raz Shack
P.S Just for kicks>>>>>
Is your circulating fan working?
Sometimes they stick and need a shot of WD 40 and then work
it back and forth a little until it wants to take off again. Keep me informed
and PLEASE give a Thumbs Up for the effort. The Raz Shack

Apr 06, 2010 | Freezers

1 Answer

I have a upright frostfree Woods freezer. It is only around 4-5 years old and this year it is making very loud running noises. It is not keeping things fully frozen.


Is your circulating fan working?
Sometimes they stick and need a shot of WD 40 and then work
it back and forth a little until it wants to take off again. Keep me informed
and PLEASE give a Thumbs Up for the effort. The Raz Shack

Mar 15, 2010 | Woods Upright Freezer MU07W

1 Answer

Power output


Use the formula P x I = E where p is 120 volts I is amps and E is watts. On the service plate it will tell you amps. That is the fan the compressor and the light. My frig is 6.5 amps full load. that would be 120x6.5=780watts.

Nov 23, 2008 | Freezers

1 Answer

Kelvinator Chest Freezer will not cool after spray painting rust spot.


Dear Landport2
Welcome to the site,

You said, you have a Kelvinator chest freezer, model number CFS101SM1W. This freezer is in excellent condition and was working ok. I notice that there was a rust spot on the bottom area so I decided to spray paint the entire inside with the appropriate appliance spray paint. After spray painting the freezer will not cool.

How old was your freezer?
This must be an ancient freezer!

And Unfortunately I was not able to tell you to leave it alone and not to turn it off!
You did not cause this!
Unfortunately it was so old that it probably was already on it's last legs.

Here is an interesting report I just read!

Repair or replace your appliances?

When to pull the plug on your old freezer

It nearly always makes sense to undertake simple do-it-yourself repairs,
such as replacing a gasket on a refrigerator or a freezer.

Typically, you'll also find a troubleshooting section for more-serious problems
in the owner's manual.

Should you pay for a repair or buy a new model ?
The answer depends mostly on the age of your ,freezer
how much you bought it for,and the cost of the repair.

Follow these guidelines:

When a repair makes sense.


If your refrigerator is under warranty or less than four years old freezers),
paying for a repair makes sense.
Note that freezer under warranty might require service from a factory-authorized technician;
readers have found them on a par with independent repairers.

When a repair might be a wise choice.


If your freezer is out of warranty and is four to seven years old,
it might make sense to pay for a repair. Customers generally pay $100 to $200 for a repair.
But you might want to buy a new model even at this stage,
given that today's models are quieter and have added features.
Higher energy efficiency is another plus: Energy Star-qualified models made after April 28, 2008,
are 43 percent more efficient than conventional models built before 2001 and 56 percent
more efficient than those built before 1993.

When it pays to replace.


The repair costs more than half the price of a comparable new freezer.
Data also shows that it doesn't pay to fix a less-expensive freezer
six or more years old .

Thanks to better recycling programs, less than 10 percent
of a freezer you replace is likely to end up in a landfill.


Thanks for giving me the opportunity to help!
Please do not for get to give a rating before you sign off!
Thank You, HUUUM




Oct 10, 2008 | Freezers

1 Answer

Whirlpool upright frost free freezer


over charging can certainly keep it from freezing depending on the pressures how much it is overcharged the sealed systems on whirlpools have a five year warranty with your history id call whirlpool cust relations and discuss this problem with them they will help not customer assistance cust relations they are different talk highly of their product and tell them you think you just got a lemon thats all and it hasn't ever worked right now Whirlpool cares about their customers most people believe that the factories just build things to last till the warranty runs out that's not true they want you happy with their product on average one unhappy customer will tell 20 people and that's bad for business they would be happy if you never had a problem with their stuff so give them a call tell your mom had Whirlpool your granny had whirlpool you got your whole kitchen whirlpool this is the first Whirlpool you've had a problem with so you think it just must be a bad unit let me know what they tell you now that's customer relations you want to call ok

Feb 20, 2008 | Freezers

Not finding what you are looking for?
Haier Chest Freezer HNCM070E Logo

Related Topics:

173 people viewed this question

Ask a Question

Usually answered in minutes!

Top Haier Freezers Experts

Victor Nwachukwu
Victor Nwachukwu

Level 2 Expert

157 Answers

christian nielsen

Level 3 Expert

358 Answers

jdthefixer

Level 3 Expert

744 Answers

Are you a Haier Freezer Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...