sumif

  • Thread starter Thread starter b166er
  • Start date Start date
B

b166er

hi members,

can i give criteria range for sumif funtion i tried but i couldn't
give criteria range.

if criteria range can not be given then how can we use or command to
give more than one arguments say i want sum in col B5 all the the sale
made by either of three salepersons(john,bush,kaven).
i dont mind if someone tell me some other function through which i
could solve that problem.
 
thanks for reply buy i want

A1 john 5555
A2 bush 20
A3 kaven 50
A4 linda 10
A5 jams 50

i just want to sum the amount of john bush and kaven in one cell there
are more than 5000 enteries keep in mind that thing as well.
 
=SUMIF($A$5:$A$8,"John",$B$5:$B$8)+SUMIF($A$5:$A$8,"bush",$B$5:$B$8)+
SUMIF($A$5:$A$8,"kaven",$B$5:$B$8)
 
hi, why not use:

=SUMIF($A$5:$A$5005,"John",$B$5:$B$5005)+SUMIF($A$5:$A$5005,"bush",$B$5:$B$5005)+SUMIF($A$5:$A$5005,"kaven",$B$5:$B$5005)

hope this helps
regards from Brazil
Marcelo





"b166er" escreveu:
 
or use an array

=SUM((IF((($A$5:$A$5005="john")+($A$5:$A$5005="bush")+($A$5:$A$5005="Kaven")),1)*$B$5:$B$5005))

Use Ctrl +shift + enter to apply array
 
=SUMPRODUCT(SUMIF(A1:A100,{"John","Bush","Kaven"},C1:C100))

as shown in the other two groups that you posted in.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top