Spreadsheet help

Reply

  #1  
Old 04-18-15, 05:59 PM
Norm201's Avatar
Member
Thread Starter
Join Date: Sep 2013
Location: USA
Posts: 6,138
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
  #2  
Old 04-20-15, 05:59 PM
Norm201's Avatar
Member
Thread Starter
Join Date: Sep 2013
Location: USA
Posts: 6,138
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)
 
Reply

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread
Display Modes