Summarizing unique data in an array 1

[jrlss]

New Tech User needs help to sum amts whenever a value is found (currently using Excel 2007). Here is the data:

A B C
A Qualifies 1000
A3 City Dallas
A4 State TX
A5 Zip 76076
A6 Qualifies 1000
A7 City Cincinatti
A8 State OH
A9 Zip 49665
A10 Qualifies 450
A11 City Los Angeles
A12 State CA
A13 Zip 90127


I need to get the sum of C wherever the value "Qualifies" is found (B2:B13="Qualifies"). I'm currently trying to modify an array:
=SUM((A2:A13="Qualifies")*(C2:C13>0)). Note: The rows listed above are all in the same order, so after A2, there will always be a "Qualifies" on the 6th row.
In the result I'd like to see the summed value written to column D2 (see below).

A B C D
A Qualifies 1000 2450

 

[SkipVought]

Hi,

This is a simple SUMIF function. No array formula needed.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jrlss]

Skip,

I've copied the code from a book and was generalizing the formula (really new user). Would this be what you are suggesting:

SUMIF((A72:A166="QUALIFIES",B72:B166>0))

I get an error for parenthesis placement. Tried this (which Excel repaired) and now I'm getting a 0 value:
=(SUM(IF(A72:A166="QUALIFIES",(B72:B166>0)))).

 

[SkipVought]

just follow the bouncing ball; ie the notations below the formula.
[tt]
=sum

SELECT SUMIF() and TAB

enter the range containg the criteria values, and COMMA

enter the criteria in QUOTES and COMMA

enter the range to sum and CLOSE PARENTHESES

ENTER
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jrlss]

Great! It worked (BTW: didn't need to hit tab). Am enjoying your various posts.

MY THANKS!

 

[SkipVought]

I guess I should have stated...
[tt]

DOWN ARROW to SUMIF() and TAB

[/tt]
all kinds of ways to skin a cat. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}