How to sum of 3 criteria

[Jadegirl]

Looking to sum three criteria? I need to find the sum of 75% of the total of REG hours for the three criteria:

(criteria 1) of column X which is only REG and OT hours) Need Reg hours

(criteria 2) of Column C filled with various numbers - I am looking for number 2.1.

(Criteria 3) of column P (ABC) filled with various alpha-numeric characters - I am looking for the number 222.

Can anyone help? I have tried several different approaches, but it isn't quite panning out.

 

[VoG]

So is it something like

=SUMPRODUCT(--(X2:X1000="REG"),--(C2:C1000=B4),--(P2:P1000=D4),AB2:AB1000)

I don't understand the 75% bit.