C
chris
Sound like you want a sumif with conditions,
you can accomplish this with an array formula as follows:
{=SUM(IF((I13:I21=I9)*(K13:K21=K9),M13:M21,0))}
adjust range to suit.... must be entered as an array
(shift enter)
you can accomplish this with an array formula as follows:
{=SUM(IF((I13:I21=I9)*(K13:K21=K9),M13:M21,0))}
adjust range to suit.... must be entered as an array
(shift enter)