Formula Help on SUMIFS

[VbaHell]

Hello all

I am trying to work out how to use a formula for the following


Column B from row 2 onwards

12345
25678
34567/SE
23456
12567/SR

Column C from row 2 onwards

23.45
14.56
13.87
21.23
28.78

column D from row 2 onwards (In Text not date format)

Jan 14
Feb 14
Mar 14
Apr 14
May 14
Etc

formula i need is something like this

=SUMIFS(C:C,B:B,<>"*SE*",B:B,<>"*SR*",D:D,="MAR 14"

Is this possible please

 

[steve the fish]

Include the not equal to inside the quotes

=SUMIFS(C:C,B:B,"<>*SE*",B:B,"<>*SR*",D:D,"MAR 14")

 

[VbaHell]

Doh off course

Thank you