I have a table importing part numbers like this: 258369F and it has about 10 spaces after it.
I want to do a sumifs formula that sums the "Qty" of any "PartNumber" that contains the string 258369 and took place in 2015
=sumifs(qty,PartNumber,$B$4,Year,"2015")
B4 of course holds the number 258369
So, I tried: =sumifs(qty,PartNumber&"*",$B$4,Year,"2015") and =sumifs(qty,PartNumber,$B$4&"*",Year,"2015") and neither work.
Bookmarks