Home

SUMIF HELP

Highlighted
Aotidae
New Contributor

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".

1 Reply
Highlighted
I figured it out.
=ROUNDUP(IF(SUM(E12*HRS!M5,F12*HRS!M3,G12*HRS!M4,H12*HRS!M2)>0,SUM(E12*HRS!M5,F12*HRS!M3,G12*HRS!M4,H12*HRS!M2,90)),0)