=SUMPRODUCT((A2:A4="111")*(B2:B4="AA")*(C2:C4="999 ")*(D2:D4="BB")*(E2:E4)

--

Vasant

"Sean" wrote in message
...
Want to sum by using four criterias two being numbers and two being
alphabetic all on a seperate worksheet from the one gathering the
information
within a range of cells. IF A2:A4 = "111" and IF B2:B4 = "AA" and IF
C2:C4 =
"999" and IF D2:D4 = "BB" THEN SUM E2:E4.

This seems complicated to me and I cannot resolve it. If anyone can help
please let me know... Thanks...