Spreadsheet help


  #1  
Old 04-18-15, 04:59 PM
Norm201's Avatar
Member
Thread Starter
Join Date: Sep 2013
Location: United States
Posts: 10,624
Received 668 Upvotes on 591 Posts
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:

 

Top Answer

 
04-20-15, 04:59 PM
Norm201's Avatar
Norm201
Norm201 is offline
Member
Thread Starter
Join Date: Sep 2013
Location: United States
Posts: 10,624
Received 668 Upvotes on 591 Posts
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)
 
  #2  
Old 04-20-15, 04:59 PM
Norm201's Avatar
Member
Thread Starter
Join Date: Sep 2013
Location: United States
Posts: 10,624
Received 668 Upvotes on 591 Posts
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)
 
brettperth, Marvinator voted this post useful.
 

Thread Tools
Search this Thread
 
Ask a Question
Question Title:
Description:
Your question will be posted in: