Posted to microsoft.public.excel.misc

Black9Medic Black9Medic is offline

external usenet poster

Posts: 4

If statement combining average

Hi,

I am creating an efficiency report and I am stuck on a problem. I am
getting a false statement when all the cells have no information in it when I
actually need that cell to remain blank when there is nothing to report.

Here is the formula I am using: =IF(COUNT(A39:C39),AVERAGE(A39:C39))
--
B9M

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining Average, Offset & Vlookup	L. Howard Kittle	Excel Worksheet Functions	4	November 14th 07 05:45 PM
Combining a OR and a AND in an IF statement	Shu of AZ	Excel Discussion (Misc queries)	3	December 24th 06 03:46 AM
Combining AND/OR in an IF statement	dread	Excel Worksheet Functions	4	July 20th 06 06:05 PM
Combining a Vlook up with and If then statement	Sweetetc	Excel Worksheet Functions	14	May 2nd 06 09:06 PM
combining an if statement	Ryder	Excel Worksheet Functions	3	March 9th 05 06:21 PM

All times are GMT +1. The time now is 10:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us