sum if

[Guest]

I need to sum the numbers in the column only if numbers appear in the same row in another column. in other words i want to sum column A contents, but only include the cell rows that have a value in column b.

 

[Aladin Akyurek]

On 2002-03-13 08:16, Anonymous wrote:
I need to sum the numbers in the column only if numbers appear in the same row in another column. in other words i want to sum column A contents, but only include the cell rows that have a value in column b.

Care to elaborate which/what condition must hold for B-cells?

 

[Guest]

Type in this formula:
=SUM(IF(ISNUMBER(B1:B100);A1:A100))
and close off by pressing Ctrl-Shift-Enter. (this is a CSE or array formula).

See http://www.mrexcel.com/tip011.shtml for more about CSE formulas.