> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of caocheng?? > Sent: Sunday, September 28, 2008 7:26 PM > To: R-help@r-project.org > Subject: [R] does there any function like sumif in excel? > > I have a data.frame datas which have two columns A and B. > I want to filter column A by some values and to get a value list which > contain the value in B. > Best wishes! >
Not sure if I am interpreting you question correctly, but you could do something like datas <-data.frame(1:10,rnorm(10)) names(datas) <- c("A","B") rslt <- datas[ datas[, 'A'] %in%(1:5) , ] where datas[,'a'] %in%(1:5) is the example filter criteria that I used for the example. What is the nature of your data, and what are your filter criteria? Dan Daniel Nordlund Bothell, WA USA ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.