rsboulevard
New Member
- Joined
- Oct 22, 2020
- Messages
- 18
- Office Version
- 2010
- Platform
- Windows
I am trying to sum hours based on a list of earnings codes using a named range called Include. My formula is =sumif(a2:a6,Include,b2:b6). It is returning a 0. My Include range is =Sheet1!$G$1:$G$3. Any ideas why it's not adding up for me? (Once I am able to get this to add up, I will subtract the Do Not Include named range)