Help with using formulas

**siurene** · 01-11-2011, 07:45 PM

Please I need big help!

I was trying to correct this excel sheet for a long time and the result of a formula was showing "#Value". I have checked many times....the formula/function is correct (which basically just the same as other ones), but for some reason it is not showing the associated results for a specific row correctly.

As you see in the attachment file, for FC 58 & FC 28 the formula is showing correctly but for some reason for FC 118 it is not showing the results at all, instead just "#Value".

Can someone please help me to see what mistake I actually have made?

Thank you so much!

**TMS** · 01-11-2011, 08:06 PM

The entries that are correct have been array entered (Control-Shift-Enter). Those that have the errors have not.

Regards

**jeffreybrown** · 01-11-2011, 08:15 PM

If you don't want to use an array formula then maybe...

=SUMPRODUCT(--($B$3:$B$33=118),--(ISNUMBER($C$3:$C$33)))

**siurene** · 01-12-2011, 01:39 PM

Thank you so much....let me try it now.

**jeffreybrown** · 01-12-2011, 02:34 PM

If you are satisfied with the information provided, please don's forget to mark the thread as solved.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

**arthurbr** · 01-12-2011, 03:48 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST