RAYSHAR1066
New Member
- Joined
- Jun 26, 2012
- Messages
- 1
I would like to added some named cells on my weekly work log.
Every week I name the total hours on a job: EX: "Frame1", the next week "Frame2", etc.
This is in a sheet with other jobs.
So, I tried: =sumif(Picked Range,"Frame*")
But, this doesn't work....
I can add them individually: =sum(Frame1,Frame2,Frame3,Frame4)
Just not by picking the entire sheet range and using a wildcard.??
Any help would be great.
Thanks..........
Every week I name the total hours on a job: EX: "Frame1", the next week "Frame2", etc.
This is in a sheet with other jobs.
So, I tried: =sumif(Picked Range,"Frame*")
But, this doesn't work....
I can add them individually: =sum(Frame1,Frame2,Frame3,Frame4)
Just not by picking the entire sheet range and using a wildcard.??
Any help would be great.
Thanks..........