Hi

One way
With last name in column A and City in column B
=SUMPRODUCT(--($A$1:$A$1000="Smith"),--($B$1:$B$1000="NYC"))

Change ranges to suit.

--
Regards
Roger Govier



"galsaba" wrote in message
ups.com...
How can I create a statement that will take in consideration criterai
in two fields.
For example, all rows where the last name is Smith, and the City is
NYC.

Thanks,
galsaba