SUMIFS using a named range

[rsboulevard]

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)

 

[Dave Patton]

Try Excel's Formula Evaluate

the -- coerces the True or False to 1 or 0 for the calculation