• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Blank cell summation

Khalil Lakhani

New Member
Hi All,
I am looking for an answer to below query -
CUST IDVALTYPE
15000Jeep
22000Porche
33200
41000
51500
Nissan
If I want to get sum of all the values in column B that corresponds to Column C (Blank cells), how should I do that? - I am looking for $4200 -
I am dealing with data that has 250K rows -
Any help would be appreciated -
Thanks,
K.
 

Attachments

  • Chandoo_Template.xlsx
    8 KB · Views: 2
Hi Khalil,

Formula would be something like this:
=SUMIF(D3:D7,"",C3:C7)

First array is the column that would have blank cells, second array is range with values to sum up.
 
Back
Top