Brent
asked on
Need help with sumifs in 2003
I thought this was completed, but I built this at home in excel 2010. But, work only has 2003, so I just figured out my =sumifs won't work.
Any suggestions on how to collect my data without using =sumifs.
Right now, I have my pivot collecting my dates and then use =sumifs to collect the time.
thanks for any help
expert-exchange.xlsx
Any suggestions on how to collect my data without using =sumifs.
Right now, I have my pivot collecting my dates and then use =sumifs to collect the time.
thanks for any help
expert-exchange.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I split it because of the help with Absolute Reference!
Thanks
Thanks
Except you probably don't want an absolute reference on the column for R4. Should be R$4.