one way:

=SUMPRODUCT(--(S1:S1000="Jane"),--(D1:D1000="apple"))

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"A. Toczko" wrote:

Hello. This is what I want to do:

I want it to look at two columns in a spreadsheet. If Column S=Jane, I want
it to count each time Column D='apple'. So it should only be looking at the
rows where S=Jane. How can this be done? Thanks.