Formula problems that keep producing a #Value! Error!!

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

		Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Formula problems that keep producing a #Value! Error!!

Home

Formula problems that keep producing a #Value! Error!!

« Previous Thread | Next Thread »

Thread Tools

Display Modes

June 21st, 2009, 06:27 AM posted to microsoft.public.excel.worksheet.functions

Danny boy

external usenet poster

Posts: 106

Formula problems that keep producing a #Value! Error!!

I am trying to get this formula to average the values in row I for all
individuals seen during the year 2008. The formula also acknowledges that it
should ignore any cell in row I, if it is blank. For some reason I canâ€™t seem
to get the formula to work, and I keep getting a #VALUE! error. Any
suggestions?

Thanks,

Dan

Below is the formula I originally wrote:
=SUMPRODUCT((--(YEAR('Raw Data'!$C$2:$C$3498)=2008)),('Raw
Data'!$I$2:$I5000)0,AVERAGE('Raw Data'!$I$2: $I5000),"")

Report this post as spam, offensive or inappropriate

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 12:36 AM.