"IF" Formula Doesn't seem to work.

[fearonc]

I am having difficulty coming up with the proper syntax for an IF formula. Maybe I should be using a different one. I have a column with numerous cell entries corresponding to software version information such as, [6.8 Beta 1], [5.0.1236], [7.004.18 Beta 2], etc. In the next column I have listed the megabyte size of these programs: [29.6], [18.3], [4.5], etc. What I want to develop is a formula that can sum only the values that are associated with the “Beta” versions. I have tried using [ IF(A1=”*Beta*”, B1,0)], but that returns a value of 0 when it should be 29.6 Any help would be appreciated. Thanks!

[dluhut]

Ignore this, tried to delete, but doesn't know how

[dluhut]

Use SumIF function.

=SUMIF (Software version information range, "*Beta*", megabyte sum range)

i.e. =SUMIF($A$2:$A$4, "*Beta*", $B$2:$B$4)

where range of column A is software information such as, [6.8 Beta 1], [5.0.1236], [7.004.18 Beta 2], etc
and range of column B is megabyte size of these programs: [29.6], [18.3], [4.5], etc