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