ExcelBanter - How to refer to a criterie in a cell using excel sum.if function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to refer to a criterie in a cell using excel sum.if function (https://www.excelbanter.com/excel-worksheet-functions/449482-how-refer-criterie-cell-using-excel-sum-if-function.html)

RuneVSP

How to refer to a criterie in a cell using excel sum.if function

Hi i cant figure out how to makte this happen.

i have added the following

=SUM.IF(A17:A21;"<5";B17:B21)

which Work perfectly fine, the problem is that i would like to have a cell reference (B14)instead of 5 but i dont know how to make it Work.

my best guess is

=SUM.HVIS(A17:A21;"B14";B17:B21)

what am i doing wrong?

Kevin@Radstock

Quote:

Originally Posted by RuneVSP (Post 1614910)

Maybe!

=SUMIF(A17:A21;"<"&B14;B17:B21)

RuneVSP

Quote:

Originally Posted by Kevin@Radstock (Post 1614911)

Maybe!

=SUMIF(A17:A21;"<"&B14;B17:B21)

Yey, it worked.Thanks.

Now that im talking to such a smart person do you know if I could somehow add a range instead. ( this is actually just a small part of trying to take the average of a given (and changeable) interval iin some coloumns

All times are GMT +1. The time now is 08:19 AM.