J
Jeremy
I have a sheet of data similar to below:
Column A Column B
3 $10
12 $25
7 $90
2 $45
14 $60
I am looking for a formula that would sum $ values in
Column B based on criteria in Column A. For example, sum
all values in column B where the value in Column A is
between 0 and 10 would give ($10+$90+$45)=$145.
To further complicate the issue, I will also be filtering
based on data in Column C, and would like the above logic
to calculate based only on the data which is shown when
the filter is applied. Thanks for your help.
Jeremy
Column A Column B
3 $10
12 $25
7 $90
2 $45
14 $60
I am looking for a formula that would sum $ values in
Column B based on criteria in Column A. For example, sum
all values in column B where the value in Column A is
between 0 and 10 would give ($10+$90+$45)=$145.
To further complicate the issue, I will also be filtering
based on data in Column C, and would like the above logic
to calculate based only on the data which is shown when
the filter is applied. Thanks for your help.
Jeremy