From: petedacook on 9 Mar 2010 18:11
You can also use an array formula:
or if you have more than one criteria, you want john and steves totals:
remember to hold ctr+shift when you hit the enter key for array formulas.
"Sam Wilson" wrote:
> You can use =SUMIF(A2:A5,"John",B2:B5)
> "John" wrote:
> > Hi,
> > I have a sheet
> > A B
> > John 100
> > Alex 150
> > John 175
> > Steve 125
> > i want to get the sum of the entries for John, say here i have to get the
> > result as 100+175 = 275. Is there any function for me to do it?
> > I tried LookUp but its returning only the first value.
> > Thanks in advance
> > John,