sum if with wildcard criteria

[Armitage2k]

Hi!

I am having troubles getting this formula to work:

=SUM(IF('Data Comp1'!C4:C100={"*.5.*"},'Data Comp1'!K4:K100,0))

Background to this formula is that I need to sum up the values in column K, depending on if the respective cell in column C has a ".5." partially in its cell value or not.

The above formula seems correct, however, only returns me 0, making me believe that I cannot do a wildcard seach with this setting.

Any ideas?
Thanks,

A2k

[zbor]

Can you upload example workbook?

[Colin Legg]

It looks like you should be using:

=SUMIF('Data Comp1'!C4:C100,"*.5.*",'Data Comp1'!K4:K100)

[Armitage2k]

Thanks Colin, that did the trick.

Cheers,
A2k

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Colin Legg]

Hi,

If you're happy with the solution provided, please mark your thread as solved.