Posted to microsoft.public.excel.worksheet.functions

Nelly[_2_] Nelly[_2_] is offline

external usenet poster

Posts: 9

Help with SUMIF or array function to ignore #VALUE!

Hi all

I need to count data that sometimes includes #VALUE! and cannot work it out

This is what I am using but now and again the data includes #VALUE and due
to tha amount of lookups I cannot ommit this from the data that is been
counted

{=SUM(($M$1:$M$357=$B400)*($F$1:$F$357=0.02))}

any help much apprieciated

Nelly

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
How do you ignore hidden rows in a SUMIF() function?	Gerry	Excel Worksheet Functions	12	October 8th 09 05:20 PM
IF Function and ignore if	Hicks	Excel Worksheet Functions	1	August 21st 08 05:05 PM
sumif array function	yshridhar	Excel Worksheet Functions	4	September 17th 07 04:46 AM
How to ignore text on SUM() function...	KLZA	Excel Worksheet Functions	16	August 4th 07 12:36 AM
Function to ignore decimals	Poliisi	Excel Worksheet Functions	1	September 6th 05 09:03 PM

All times are GMT +1. The time now is 06:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us