Something like:

=SUMPRODUCT((A1:A40="1a")*(B1:B40=1))


"blopreste3180" wrote in message
...
how do i get excel to give me the sum if two criteria are true, but i want
it
to return a value of only one of the criteria. For example, column A is
the
text 1A, column B is number 1. i need a formula that says if test in
column
A="1A" AND column B="1", then return the total number of times that "1A"
appears in column A.