| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Criteria with "<" or ">" in sumif()
Hi, my excel version doesn't recognise the arrows in sumif formulas. What
can I do to make it work? Thanks heaps. |
|
#2
|
|||
|
|||
|
Hi!
What does your formula look like? To use a logical operator, try one of these: =SUMIF(A1:A10,"5") =SUMIF(A1:A10,""&5) Biff -----Original Message----- Hi, my excel version doesn't recognise the arrows in sumif formulas. What can I do to make it work? Thanks heaps. . |
|
#3
|
|||
|
|||
|
or
=SUMIF(A1:A10,""&H1,B1:B10) to cover the value in another cell and summing a different row. -- HTH RP (remove nothere from the email address if mailing direct) "Biff" wrote in message ... Hi! What does your formula look like? To use a logical operator, try one of these: =SUMIF(A1:A10,"5") =SUMIF(A1:A10,""&5) Biff -----Original Message----- Hi, my excel version doesn't recognise the arrows in sumif formulas. What can I do to make it work? Thanks heaps. . |
|
#4
|
|||
|
|||
|
There's an example of using SUMIF with an operator he
http://www.contextures.com/xlFunctions01.html#Operator Loan wrote: Hi, my excel version doesn't recognise the arrows in sumif formulas. What can I do to make it work? Thanks heaps. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| SUMIF Criteria | Excel Discussion (Misc queries) | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
| SUMIF with more than 1 criteria | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Linear Mode
