Find Specific Dollar Amount Depending on Range

Question

I've had this answered here before, but cannot find the Thread nor can I find the Book I was using with the formula.

I have a formula =SUMIF(Sheet2!C1:C99,A1,Sheet2!D1:D99) that I use to find a Dollar amount depending on a word; or in this case, an Employee's name.

Sheet2 contains employee names (C1:C99) and their Pay Rates (D1:D99) beside each name.

The formula finds the Name that is on Sheet2 that corrisponds to the name on A1 to insert their pay rate.

I want it to be able to find a Pay Rate between $4.75 and $6.00. Or anything below $6.00.

Answer 1

Try

=SUMIFS(Sheet2!D1:D99,Sheet2!C1:C99,A1,Sheet2!D1:D99,"<6")

Note that the functions is sumifS

if you want to include 6 then use

=SUMIFS(Sheet2!D1:D99,Sheet2!C1:C99,A1,Sheet2!D1:D99,"<=6")

to check for the range 4.75 to 6 (both inclusive) use

=SUMIFS(Sheet2!D1:D99,Sheet2!C1:C99,A1,Sheet2!D1:D99,">=4.75",Sheet2!D1:D99,"<=6")

Answer 2

=SUMIFS(Sheet2!D1:D99,Sheet2!C1:C99,A1,Sheet2!D1:D99,"<6")

This formula worked exactly as I needed it to. Thank you very much.