> >
>

#1
04-18-15, 04:59 PM
Member
Join Date: Sep 2013
Location: United States
Posts: 10,966

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:

04-20-15, 04:59 PM
Norm201
Member
Join Date: Sep 2013
Location: United States
Posts: 10,966
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
04-20-15, 04:59 PM
Member
Join Date: Sep 2013
Location: United States
Posts: 10,966
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)

Marvinator voted this post useful.