# recognize the text in dates...

#### Hylke

##### New Member
Is it possible to derive a formula from a table like this?:
if date in colum A contains the text "feb" then add all figures correspondant in colum B (=183)
____A______B__
1l 1-jan-05....l...23
2l 2-jan-05....l...64
3l 3-jan-05....l...67
4l 6-feb-05....l...43
5l 5-feb-05....l...60
6l 6-feb-05....l...80
7l 7-mar-05...l...67
8l 8-mar-05...l...52
9l 9-mar-05...l...43

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Hi,

Do you mean

=SUMPRODUCT(--(TEXT(A1:A10,"MMM")="Feb"),B1:B10)

or

=SUMIF(A1:A10,"*feb*",B1:B10)

?

Thanx!

Thanx buddy...
Some things just seem more complicated than they really are!
Works like a charn!

Replies
17
Views
305
Replies
3
Views
126
Replies
3
Views
137
Replies
48
Views
714
Replies
7
Views
158

1,196,369
Messages
6,014,889
Members
441,854
Latest member
Amstaff

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back