Try this array formula

=SUM(--(FREQUENCY(IF(D2:D610="whatever",MATCH(A2:A610,A2: A610,0)),
ROW(INDIRECT("1:"&ROWS(A2:A610))))0))

--
__________________________________
HTH

Bob

"Peta" wrote in message
...
Hi, using the fomula below I need to incorporate another column (D -
groups)
to split the total result I already have. Do I use another COUNTIF
function?


=SUMPRODUCT((A2:A610<"")/COUNTIF(A2:A610,A2:A610&""))
--
Peet