Hi,
Try:

=sum((A1:A10="60-22677")*(B1:B10="IL")*(C1:C10)) and enter as array formula
as before

HTH

"Leona" wrote:

Mark --

We've tried and are still not getting a valid response. We've done a test
so that we can determine what the valid response should be. Instead of
coming up with the numeric value, we're getting a zero. It shouldn't be zero
(as in no items counted), so it must be an indicator of a false in the nested
if functions somewhere. Any ideas? Thanks

"Leona" wrote:

Using either AND function, or nested IF functions, I'm trying to sum data in
a third column for only those items that meet both of the requirements in the
AND function. I can manage to sum the entire column. Any ideas? Thanks