sum if

Mar 13th, 2002, 09:16 AM

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 · Mar 13th, 2002, 09:22 AM

Quote:

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?

Mar 13th, 2002, 09:40 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 09:16 AM	#1
Guest Posts: n/a	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.

Mar 13th, 2002, 09:40 AM	#3
Guest Posts: n/a	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.