| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? Last edited by RuneVSP : November 13th 13 at 10:18 AM |
|
#2
|
|||
|
|||
|
Quote:
=SUMIF(A17:A21;"<"&B14;B17:B21) |
|
#3
|
|||
|
|||
|
Quote:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting data for a chart based on specific criterie | Excel Programming | |||
| How do I refer to the results of a function in a cell not the form | Excel Worksheet Functions | |||
| How to refer to the value of a cell containing a VBA function? | Excel Programming | |||
| Refer to selected cell in custom function | Excel Programming | |||
| Refer to the cell in which a function is entered. | Excel Programming | |||
Linear Mode
