You could apply SUM to both columns and then go and change the subtotal
formula on one from =SUBTOTAL(9,... to =SUBTOTAL(3,... on each subtotal
(this could be done with Replace Ctrl-H).

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Abdul" wrote in message
...
Hello!,

Is there a way in Excel (2007) that I can use more than one function
in a Subtotal?

For eg:

I want my Column A to use COUNTA and Column B:F to use SUM Function

Thanks