Jan 30 2019 08:13 AM
The formula I need help with is "=ROUNDUP(SUMIFS(B12 ">0",E12*HRS!M5,F12*HRS!M3,G12*HRS!M4,H12*HRS!M2, 90),0)"
The aim is to initiate: Sum(E12*HRS!M5,F12*HRS!M3,G12*HRS!M4,H12*HRS!M2, 90)
if B12>0 or >=1.
The other situation could be IF E12*HRS!M5,F12*HRS!M3,G12*HRS!M4,H12*HRS!M2 ">0" "+90".
Jan 30 2019 08:31 AM