A
ASPENCO
Given the following data I would like to create one formula tha
performs two separate functions:
Column A Column B
15 $5,000
35 $2,000
20 $10,000
50 $7,000
First, I would like the formula to identify those cells (not th
values) within the range of A1:A4 that meet the criteria >22.
Second, I would like to take each of those cells separately (not th
sum of the cells) and multiply by another cell and the adjacent valu
in Column B and then sum these products.
As always, I greatly appreciate your assistance
performs two separate functions:
Column A Column B
15 $5,000
35 $2,000
20 $10,000
50 $7,000
First, I would like the formula to identify those cells (not th
values) within the range of A1:A4 that meet the criteria >22.
Second, I would like to take each of those cells separately (not th
sum of the cells) and multiply by another cell and the adjacent valu
in Column B and then sum these products.
As always, I greatly appreciate your assistance