View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg Greg is offline
external usenet poster
 
Posts: 331
Default SUMIF WITH AND OR ANOTHER SUGGESTION

Looking to sumif A1 and B1 = "MOTOROLA JXP1" then C1 would be the anwser

A B C
1 MOTOROLA JXP 1 4
2 MOTOROLA JXP 2 5
3 MOTOROLA JXP 3 6
4 MOTOROLA JXP 4 8


Thanks, Greg