SUMIF

's Computer Specifications

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

's Computer Specifications

Robert,

Something along the lines of:

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

HTH,
Bernie
MS Excel MVP

"Robert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"	=?Utf-8?B?SGFycnkgU2V5bW91cg==?=	Microsoft Excel Worksheet Functions	9	12th Jun 2007 11:47 PM
Embedding a Sumif in a sumif	=?Utf-8?B?Qy5QZmx1Z3JhdGg=?=	Microsoft Excel Worksheet Functions	5	31st Aug 2005 08:31 PM
nested sumif or sumif with two criteria	=?Utf-8?B?ZHNoaWdsZXk=?=	Microsoft Excel Worksheet Functions	5	5th Apr 2005 04:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function	Oscar	Microsoft Excel Worksheet Functions	2	12th Jan 2005 12:01 AM
Sumif	Stewy p	Microsoft Excel Worksheet Functions	3	28th Nov 2003 08:12 PM