SUMIF

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Too many arguements for this function"....ohh noooo.... 3
"Too many arguements for this function".....ohh nooo.... 2
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Sumif using Arrays 2
Using SUM + INDEX in array formula 5
SUMIF over multiple spreadsheets 4
Calculating %'s with IF and Sum/SumIF 12
subtotal with sumif nested 1

Top