This does work except for on the sheet that is linked to
the original sheet. It won't go past 24:00. That cell also
is formatted to [hh]:mm but it won't work.
-----Original Message-----
Troy,
Use a custom number format of [hh]:mm or [hh]:mm:ss .
Sorry for not being more specific but this is what I need
Sheet 1:
AI7:AI1000 recalls the numeric month number from A7:A1000
Sheet 2 (Totals):
Monthly Totals
When AI7:AI1000 is equal to (for example) month 4 the get
the total of everyother cell beginning at B7:B1000 for the
month 4 corresponding cells.
I hope this isn't too confusing.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.