SUMIFS and Wildcard

[Simonc64]

Hi all, Ive researched this problem here without an exact answer to my problem so oping you can help!

I have a s/sheet with the following........

Column A contains Job Titles

Column B contains Salary Cost

Column C contains Cost Centres

What I want to do is very simple ie sum the "salary cost" based on job title for specific cost centres - the problem is that several cost centres contain the same job title.

My approach was

=SUMIFS($B:$B,$A:$A,$A$25,$C:$C,"*08*")

Thining that this would sum the costs for all job titles (A25) where the cost centre starts with 08 but it doesnt! Any help gratefully received.

Thanks

 

[Aladin Akyurek]

just a 0 result

You have probably just numbers formatted to display leading 0's.

Let E2 house a job title and F2 '08. Note the single quote.

Something like...

=SUMPRODUCT(
  $B$2:$B$400,
  --($A$2:$A$400=$E2)
  --(LEFT($C$2:$C$4+0,LEN($F2+0))+0=$F2+0))

Note that an entry in C like 008679 would be counted in.