Selecting cell value for a sum, based on a condition

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andy (spam_at_goaway.now)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 01:28:52 GMT

Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
this:

        A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F. Floor 4.00 .40
5 S.F. Wall 5.00 .50
6 Each 6.00 .60

In the above example, The amounts at B2, C3, C4 and B5 would be summed. Any
ideas?

Relevant Pages

  • Selecting cell value for a sum, based on a condition
    ... goto Data--Filter--Autofilter and click on ... the 'each' variety, one value ... >will be used in the sum. ... the "square foot" variety, ...
    (microsoft.public.excel.misc)
  • Re: Selecting cell value for a sum, based on a condition
    ... Peo Sjoblom ... "Andy" wrote in message ... If the condition is of the 'each' variety, ... > will be used in the sum. ...
    (microsoft.public.excel.misc)
  • Re: Converting text to numbers with a twist
    ... to numbers in a variety of ways: ... using the left, right, and len functions, but I'm assuming they are being ... returned as text because when I sum them I get zero. ...
    (microsoft.public.excel.misc)
  • Re: Need help creating a formula
    ... > of column K, then subtract the sum of column K from the sum of column E, then ... > divide this # by the sum of column E. I've tried a variety of combinations ...
    (microsoft.public.excel.newusers)