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:

=SUBTOTAL(9,C3:C5)+SUMIF(B3:B7,"apples",C3:C7)