• 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.

Conditional Sum for Large Data

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.
 
Back
Top