Sumifs and countif using a wildcard

Hi All

I'm trying my hands on this unusual SUMIFS. I'm summing a host of transactions and reconciling against imprest given at the start of day. My focus is on only branch spend, which has invoice code ending 457. The first condition is the result must equal the Imprest(values in bold). The criteria is Date and Invoice code ending 457. I've tried calculating this but doesn't seem to work. Will appreciate some insight with this. Many thanks

Hello
Try SUMIFS, for example in B4 copied down to B10:

Formula:

Please Login or Register  to view this content.

Hope this helps.
DBY