Some options...
=SUM(COUNTIF(Range,{37,39}))
=SUMPRODUCT(ISNUMBER(MATCH(Range,{37,39},0))+0)
If X2:Y2 houses the criterion numbers (i.e., 37, 39)...
=SUMPRODUCT(ISNUMBER(MATCH(Range,X2:Y2,0))+0)
jcrown wrote:
Hello,
I am trying to get a function to calculate for me a group of numbers.
Example: I have in one column 38, 39, 37, 39. I want to know if there is a
function that I can use that will calculate out the amount of 39 & 37. (the
answer I am looking for would be 3). Please help. thanks, joe
|