Hi,

I have 2 columns, for example:

Col A Col B
Row 2 TIME PROJECT
Row 3 0.5 Admin
Row 4 1.25 Billable
Row 5 2.0 HR
Row 6 5.0 Billable

I would like to be able to sum the numbers in Col A when I have autofilter
on Col B. In other words, I want it to automatically calculate that there
have been 6.25 hours spent on Billable. Any ideas how to do this?

Thanks!

I would like to

If you numbers are upto row 100 then enter
=subtotal(9,A1:A100) in A101 to get what you want

"Drea" wrote:

Hi,

I have 2 columns, for example:

Col A Col B
Row 2 TIME PROJECT
Row 3 0.5 Admin
Row 4 1.25 Billable
Row 5 2.0 HR
Row 6 5.0 Billable

I would like to be able to sum the numbers in Col A when I have autofilter
on Col B. In other words, I want it to automatically calculate that there
have been 6.25 hours spent on Billable. Any ideas how to do this?

Thanks!

I would like to