Prev: HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES
Next: IF Function
From: Dazed&Confused on 24 May 2010 11:35
Hi Steve,

The trouble with SUMPRODUCT is that it eats memory and slows this ancient PC
to a crawl.

Oh well

Paul

"Steve Dunn" wrote:

> 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
>
First  |  Prev  | 
Pages: 1 2
Prev: HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES
Next: IF Function