Home

SUMIF HELP

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
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)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies