I'd like to be able to create a cell which is the sum of the values in
column A, but only if the value of column B in the cell beside the
value in Column A is equal to some number (like = 12).
So that for this
col A col B
3 45
30 12
34 12
Sum of Column A where column B is also =12 would be 30+34 = 64
(I'd end up wanting a bunch of cells like this, using different numbers
instead of 12, ie another cell that has the sum of column A where column
B is =11)
What's the best way to do this?
--
yozzdi
------------------------------------------------------------------------
yozzdi's Profile:
http://www.excelforum.com/member.php...o&userid=30376
View this thread:
http://www.excelforum.com/showthread...hreadid=532909