Home > Solved Help > Solved: Help With Formula Please.

# Solved: Help With Formula Please.

Solve Random Solve Office ALL How-tos Win 10 Win 8 Win 7 Win XP Win Vista Win 95/98 Win NT Win Me Win 2000 Win 2012 Win 2008 Win 2003 If you're seeing this message, it means we're having trouble loading external resources on our website. Second one returns #Value in third segment of the formula TRUE*(0+($Q$23=#VALUE)*$AY35+($Q$22=BV$31)*$BA35+($ Q$21=BV$31)*$BC35+($Q$20=BV$31*$BE35)+($Q$19=BV$31)*$BG35+($Q$18=BV$31)*$BI 35+($Q$17=BV$31)*$BK35+($Q$16=BV$31)*$BM35+($Q$15=BV$31)*$BO35)$AW35 etc are numeric. First suggestion works fine. have a peek at these guys

thanks for letting me know where to post for future requests. Advertisement snoozee Thread Starter Joined: Apr 10, 2006 Messages: 201 Hi I need a formula that will calculate the following In cell C22 I need a formula that will look at Report • #3 mmcconaghy October 21, 2014 at 03:15:09 Not sure how your sheet is set up but for SUMIFS()the column you want summed goes first SUMIFS( sum_range, criteria_range1, criteria1, criteria_range2, James Thurber Reply With Quote 09-21-2010,03:55 AM #5 macropod View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Jul 2008 Posts 2,748 Location Hi xld, Well spotted!

If you're not already familiar with forums, watch our Welcome Guide to get started. Solved: Formula Help - Please :-) Discussion in 'Business Applications' started by snoozee, Jun 11, 2015. so I just checked for when C2 is not empty Paul _____________________________________________________________ “True wisdom is knowing what you don't know” -- Confucius, Sayings of Confucius Reply With Quote 10-08-2016,08:44 AM #8 my site Use tags when posting code to the thread, Mark your thread as Solved if satisfied by using the Thread Tools options.

Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Report • #5 mmcconaghy October 21, 2014 at 05:16:01 Sorry, I don't understand what your looking for.Please post a small sample of your datamake sure to include Row Numbers and Column All rights reserved. For example, solveÂ -9x+10xÂ²+8=14.

1. Results 1 to 5 of 5 Thread: Help with a EXCEL formula Please [SOLVED] Thread Tools Show Printable Version Search Thread Advanced Search April 2nd, 2003 #1 brendan_harkin View Profile
2. Ozgrid is Not Associated With Microsoft.

IDS: RICTFH --- Greenville RICS7X -- Findlay RICJOK --- Marion RIC2N7 --- Clyde P959DO --- Benton Harbor Basically, I assume I need to write an IF statement to display the given You may have to register before you can post: click the register link above to proceed. Results 1 to 8 of 8 Thread: Help with formula please Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Click here to join today!

See More: Help with excel formulas please Report • ✔ Best Answer DerbyDad03 October 21, 2014 at 11:04:50 valziemick2207,Try this...=SUMPRODUCT($P$2:$R$108*($E$2:$E$108=AC44))Click Here Before Posting Data or VBA Code ---> How To Post Yes, my password is: Forgot your password? I'm a novice w/ formulas. Copyright © 2004 - VBA Express Register Help Remember Me? Portal Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Knowledgebase Articles Blogs Resources Consulting Services

You may have to register before you can post: click the register link above to proceed. All Rights ReservedAd Choices The information on Computing.Net is the opinions of its users. Management would like to display their respective Site locations instead of the IDs. Thanks to your replies I have the solved and the calculations are spot on.