D
Drea
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
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