SUMIF

[Robert]

Hello,

Can someone tell me which formula to use when I want the sum of the
numbers in column B for which the 3rd and 4th number in column is 4
respectively 0 ("04")?
A B
1 00401 10
2 00402 15
3 00403 20
4 00410 25
5 00420 30


ThanX a lot for your assistance.

Rgds,
Robert

 

[Bernie Deitrick]

Robert,

Something along the lines of:

=SUMIF(A1:A10,"?04??",B1:B10)

HTH,
Bernie
MS Excel MVP