=Sum(IIf([Date]<#7/1/2019#,IIf([GrpIndiv]="Individual",([Hours])*50.23,(IIf([GrpIndiv]="Individual",([Hours])*50.26)))))
THis only works for those meeting the 1st criteria...not if it's > 7/1
What am I missing?
I get no data at all for the 7/1 criteria.
THis only works for those meeting the 1st criteria...not if it's > 7/1
What am I missing?
I get no data at all for the 7/1 criteria.