How to get total "conditional sum of cells" in a column?

[sherifffruitfly]

Hi all,

I have dollar amounts in one col, and status in another. I want the
sum of those dollar amounts where the corresponding status cell is
empty (blank). How do I do this?

Thanks for any hints,

cdj

 

[Sandy Mann]

Status in Column A and dollar amounts in Column B:

=SUMPRODUCT((A2:A100="")*B2:B100)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gord Dibben]

=SUMIF(B1:B20,"",A1:A20)


Gord Dibben MS Excel MVP

 

[Castell]

Use the SUMIFS function. For example, =SUMIFS(A1:A12,B1:B12,"").

 

[Shane Devenshire]

Hi CDJ,

You want to use =SUMIF(StatusRange,"<>",DollarRange)

Where StatusRange is the column containing the status and DollarRange is the column containing the dollar amounts.

Cheers,
Shane

 

[sherifffruitfly]

Hi CDJ,

You want to use =SUMIF(StatusRange,"<>",DollarRange)

Where StatusRange is the column containing the status and DollarRange is the column containing the dollar amounts.

Cheers,
Shane








- Show quoted text -

Awesome - thanks everyone!