Question about Haier Chest Freezer HNCM070E

# 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

• Level 1:

An expert who has achieved level 1.

• Contributor

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

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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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

### 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

### 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.

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

### 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

### 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>>>>>
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

### 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.

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

### 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

### 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.

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!

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 ?
how much you bought it for,and the cost of the repair.

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

### Whirlpool upright frost free freezer

Feb 20, 2008 | Freezers

## Open Questions:

#### Related Topics:

173 people viewed this question

Level 2 Expert