One way:
=SUMPRODUCT(--(A516:A519=37)) + SUMPRODUCT(--(A516:A519=39))
"jcrown" wrote in message
...
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
|