Timesheet

[Fogharty]

I don't know where to begin with a formula. It's for a personal
timesheet of sorts; I have Excel 2008.

Among other things, I'm tracking work time per title. The titles are
in seven categories. I want to figure out which categories are more
lucrative. Right now, discounting irrelevant columns, here's how the
data is laid out:

A [formula] Total time spent
B Amount paid
C [formula] Hourly rate
D Article category

I have hundreds of rows of this data, one worksheet per month. It's
separated by day because I have daily quotas (so any formula needs to
ignore blanks).

What I want is a month-by-month summary of average hourly rate (column
C) for each article category (column D). I have a summary sheet for
some other stats, but COUNT formulas are about as far as my formula
knowledge goes.

Can anyone help?

 

[CyberTaz]

I'm not totally clear on the arrangement/specifics of your data, but have a
look at the SUMIF() & AVERAGEIF() functions in Excel Help. If I'm on the
right track they should be one approach to what you want.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Fogharty]

That worked!
Thank you so much, Bob.
I really appreciate it.