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

  • Thread starter sherifffruitfly
  • Start date
S

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
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

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
 
S

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 -
Click to expand...

Awesome - thanks everyone!
 
Top