I've been looking at SUMIFS for the first time. In the MS help, they refer to using wildcard characters ? and *
One thing I would like to be able to do is use a formula like this to sum the contents of column O:O whereever there is mention of Mick within column Y:Y.
Column Y:Y contains notes up to 100 characters against each line item to do with delivery times, contact details etc.
=SUMIFS(Sheet1!O:O,Sheet1!Y:Y,"=*mick")
Thanks
tw
Bookmarks