I'm not an Exceller, but I agree the syntax looks wrong.
1) The syntax for combining logical values is the AND(<l1>,<l2>).
2) I think the '*' has been working only because the logical result is
internally a 1 or a 0. It's not proper syntax - it's an accident of
implementation.
3) I'd recommend you rewrite it to use AND(), and do it all inside an IF().
4) If you're going to work on this a long time, I'd seriously consider
making it a macro and calling it.
This is the structure, broken down:
if Bcol = 'H' and Ccol < 9 sum Fcol
if Bcol = 'H' and Ccol = '8a' sum Fcol
Add the two sums together (!)
Note they're testing Bcol for 'H' twice each time, and always adding two
sums together, whether or not either one was ever calculated.
Logic should be:
if Bcol = 'H' and (Ccol < 9 or Ccol = '8a) sum Fcol
else return 0
Dan Covill
On 11/5/2010 1:22 PM, Stephen Russell wrote:
> On Fri, Nov 5, 2010 at 2:54 PM, MB Software Solutions, LLC
> <[email protected]> wrote:
>> User has problem with this formula:
>>
>> =SUM(IF(($B$11:$B$26="H")*($C$11:$C$26<9),$F$11:$F$26))+SUM(IF(($B$11:$B$26="H")*($C$11:$C$26="8a"),$F$11:$F$26))
>
> Think you need to evaluate your IF and SUM inside of that.
>
> Sum(if(($B$11:$B$26='H' ) that makes no sense to me.
>
> The if needs the T/F first and then the range to sum.
>
>
> HTH
>
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
