Formula =SUMIF for a sum range of the first 4 digits only in the cells

[schrieber]

I'm using =SUMIFS($D$18:$D$33,$B$18:$B$33,B4) which works well, but I need the formula to read only the first 4 digits in the sum range of $D$18:$D$33 then have those first 4 digits that match what is in B4 so that it can return the sum of the criteria range $B$18:$B$33. Can this be done? (The data in the cells will be changing each month, so each month I will edit the 4 digits in B4 and need to have the first 4 digits of the sum range match what is in B4.) Can this be done? Thanks in advance!

 

[awoohaw]

@ awoohaw: You don't need to use the "--" with multiplication

I know, but I learned it with other matrix math and it is ingrained. I'll do better!

@schrieber , my apologies on not taking the "=" sign out.