MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combination of functions

Posted by Johan on May 06, 2001 9:39 AM

Can I combine the subtotal function with the sumif or the countif function?

Posted by Kevin James on May 06, 2001 12:31 PM

Hello Johan,

I just tried it. It doesn't appear it is allowed WITHIN the Subtotal syntax. However, this is allowed: