Prev: HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES
Next: IF Function
From: DogmaDot on 21 May 2010 11:15
I need to find the total from Col B if Col A is one of the 3 possibilities

A B
DONE 0
DONE 60
OBS 40
POST 55
DONE 40
DONE 0
DONE 47
POST 55

DONE RESULT
OBS RESULT
POST RESULT
From: Jacob Skaria on 21 May 2010 11:24
Try the below for total for "Post"
=SUMIF(A:A,"Post",B:B)

'Try the below for total of all three
=SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B))


--
Jacob (MVP - Excel)


"DogmaDot" wrote:

> I need to find the total from Col B if Col A is one of the 3 possibilities
>
> A B
> DONE 0
> DONE 60
> OBS 40
> POST 55
> DONE 40
> DONE 0
> DONE 47
> POST 55
>
> DONE RESULT
> OBS RESULT
> POST RESULT
From: T. Valko on 21 May 2010 11:25
To sum for "done"...

=SUMIF(A1:A10,"done",B1:B10)

--
Biff
Microsoft Excel MVP


"DogmaDot" <DogmaDot(a)discussions.microsoft.com> wrote in message
news:29093D30-1E44-4A15-A2B8-FF84CE4E87EE(a)microsoft.com...
>I need to find the total from Col B if Col A is one of the 3 possibilities
>
> A B
> DONE 0
> DONE 60
> OBS 40
> POST 55
> DONE 40
> DONE 0
> DONE 47
> POST 55
>
> DONE RESULT
> OBS RESULT
> POST RESULT


From: Dazed&Confused on 24 May 2010 10:58
Hi Jacob,

A quick question
Is it possible to replace the criteria inside the curley brackets with cell
references (I'm getting an error message)?

Thanks

Paul

"Jacob Skaria" wrote:

> Try the below for total for "Post"
> =SUMIF(A:A,"Post",B:B)
>
> 'Try the below for total of all three
> =SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B))
>
>
> --
> Jacob (MVP - Excel)
>
>
> "DogmaDot" wrote:
>
> > I need to find the total from Col B if Col A is one of the 3 possibilities
> >
> > A B
> > DONE 0
> > DONE 60
> > OBS 40
> > POST 55
> > DONE 40
> > DONE 0
> > DONE 47
> > POST 55
> >
> > DONE RESULT
> > OBS RESULT
> > POST RESULT
From: Steve Dunn on 24 May 2010 11:19
Hi Paul,

you could replace the criteria with a range if you used SUMPRODUCT instead
of SUM.

=SUMPRODUCT(SUMIF(A:A,D2:D4,B:B))




"Dazed&Confused" <DazedConfused(a)discussions.microsoft.com> wrote in message
news:2B08D6EE-A2BB-4FEC-A073-C4EA7D6B8835(a)microsoft.com...
> Hi Jacob,
>
> A quick question
> Is it possible to replace the criteria inside the curley brackets with
> cell
> references (I'm getting an error message)?
>
> Thanks
>
> Paul
>
> "Jacob Skaria" wrote:
>
>> Try the below for total for "Post"
>> =SUMIF(A:A,"Post",B:B)
>>
>> 'Try the below for total of all three
>> =SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B))
>>
>>
>> --
>> Jacob (MVP - Excel)
>>
>>
>> "DogmaDot" wrote:
>>
>> > I need to find the total from Col B if Col A is one of the 3
>> > possibilities
>> >
>> > A B
>> > DONE 0
>> > DONE 60
>> > OBS 40
>> > POST 55
>> > DONE 40
>> > DONE 0
>> > DONE 47
>> > POST 55
>> >
>> > DONE RESULT
>> > OBS RESULT
>> > POST RESULT

 |  Next  |  Last
Pages: 1 2
Prev: HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES
Next: IF Function