gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
=SUMIFS(qry_OnTimeDelivery_MetricData[MONTH1_DUE],qry_OnTimeDelivery_MetricData[Category],$B5,qry_OnTimeDelivery_MetricData[TAT],">"&"0")
This is not working. I want to sum if the value in [TAT] is greater than 0 (zero)
Or I can use a formula that sums if [TAT] is not null
I tried
=SUMIFS(qry_OnTimeDelivery_MetricData[MONTH1_DUE],qry_OnTimeDelivery_MetricData[Category],$B5,qry_OnTimeDelivery_MetricData[TAT],">"&$E2) and put a 0 in cell E2 but that didn't work either.
This is not working. I want to sum if the value in [TAT] is greater than 0 (zero)
Or I can use a formula that sums if [TAT] is not null
I tried
=SUMIFS(qry_OnTimeDelivery_MetricData[MONTH1_DUE],qry_OnTimeDelivery_MetricData[Category],$B5,qry_OnTimeDelivery_MetricData[TAT],">"&$E2) and put a 0 in cell E2 but that didn't work either.