Forum Discussion
Sold items in storage
I want to know how many Sold items that are still inn storage. Colum B shows how many items of each model is in storage. Colum C shows how many items of each model is sold. Somthimes we have 1 in ...
Hi Sebastian
That could be array formula
=SUM(IF($B$2:$B$7<=$C$2:$C$7,$B$2:$B$7,$C$2:$C$7))
or regular one
=SUMPRODUCT(($B$2:$B$7<=$C$2:$C$7)*$B$2:$B$7+$C$2:$C$7*($B$2:$B$7>$C$2:$C$7))
Attached
Thank you so mutch! :-D It helped alot!