Combining Multiple IF(COUNTIF) Functions

Welcome to the forum. Several things have to be assumed in formulating a solution, which is why it is better to "Go Advanced" and upload a sample file.
1) The summation will be in W17.
2) There is already some value assigned to W17.
3) There are assigned values in K11:K24

This solution utilizes a great feature of a spreadsheet which is that you have a lot of real estate to work with so you can use helper columns (I used column X so that you could see how things are working, but you could just as easily use column XFD, and you can always hide whatever column you use). I put the following formula in X11:

Please Login or Register  to view this content.

and after I entered the formula I dragged the fill handle down to X24 (which automatically changed the row numbers in the formula as I went). I then entered the following formula in W17:

Please Login or Register  to view this content.

where 25 is the value pre-assigned to W17. Take a look at the attached file and see if this solution meets your needs.

Combining Functions.xlsx

Let me know if you have any questions.

Hi, welcome to the forum

[QUOTE]Where D11:I11 is the row range, "Avery" is the associates name, +K11 is the value from the third cell, and W17 is current cell with the formula in it.[/QUOTE]

Do you mean that your formula is going into W17? If so, this will cause a circular error - something you need to avoid at all costs, unless you have a specific need for that.

Aslo, why are you adding 0?
=IF(COUNTIF(D11:I11,"Avery")>0,+K11,W17+0)

If you want to count something over a range or rows, just include the whole range...
=IF(COUNTIF(D11:I15,"Avery")>0,K11,W170)

Can you post a SMALL sample file and show us what result you expect?

A SMALL file will have about 20 rows worth of data.