Flora Edwards
asked on
SUMIFs to exclude values
i am using below formula to exclude values with certain strings.
=SUM($A$2:$A$1000)-SUMPROD UCT(SUMIF( $B$2:$B$10 00,{"Maria ","Greg"," Gary"},$A$ 2:$A$1000) )
is this correct way to do it? or is there any better way to do this?
=SUM($A$2:$A$1000)-SUMPROD
is this correct way to do it? or is there any better way to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER