A
Andy
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?
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?