Excel Array formula for sum if combination

Excel Array formula for sum if combination

Can some one help me out with the formula
=SUM(((((IF(('RAW Data'!B3:B501="Riz Wan")*('RAW Data'!A3:A501="Active
Client"),'RAW Data'!C3:C501))+(IF(('RAW Data'!B3:B501="Riz Wan")*('RAW
Data'!A3:A501="Don"),'RAW Data'!C3:C501))+(IF(('RAW Data'!B3:B501="Riz
Wan")*('RAW Data'!A3:A501="WSUZ"),'RAW Data'!C3:C501))+(IF(('RAW
Data'!B3:B501="Riz Wan")*('RAW Data'!A3:A501="MYS"),'RAW
Data'!C3:C501))))))
When I entered this formula this works good some times and this doesn't
work sometimes I request someone to help me out on this, it's very
critical for me pull the reports it is not calculating as expected.