Hi

Expand it to include column Y

AH10: =sumproduct(--($aa$20:$aa$29=AG10),--($Z$20:$Z$29="W"),($y$10:$y$29))


rylo