Welcome to the DoItYourself Forums!

To post questions, help other DIYers and reduce advertising (like the one on your left), join our DIY community. It's free!

Spreadsheet help


Norm201's Avatar
Member

Join Date: Sep 2013
Posts: 4,647
NY

04-18-15, 04:59 PM   #1 (permalink)  
Spreadsheet help

I should know this but I seem to be drawing a blank. I have a column of numbers in Col B (quantity of items for instance). Next to each cell in Col C, I have, say a date when those numbers in the adjacent cell are used. I want to add those quantities remaining that have not been used(in this case 10) and put that total in cell C1 (where question mark is). This list could get very long, perhaps in the 300 to 500 lines long. So I need something "elegant".
Anybody want to try and take a stab at this? note: Col A is nothing more than an identifier and will most likely have peoples names in it.
Example:


 
Sponsored Links
Norm201's Avatar
Member

Join Date: Sep 2013
Posts: 4,647
NY

04-20-15, 04:59 PM   #2 (permalink)  
For those that might be interested, I got the answer.

Thanks to kweaver at Windows Secrets Lounge, he offered the following solutions:

One way: =SUMPRODUCT(ISBLANK(C3:C9)*B3:B9) and adjust the range accordingly.

Another option: =SUMIF(C3:C9,"",B3:B9)

 
Search this Thread