|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 23rd, 2004, 12:10 AM
|
|||
|
|||
Sumif formula greater than a particular cell
Is there a way to use the sumif formula so that the
criteria is a a particular cell. Ideally I'd like the formula =sumif(A1:A10,E1,B1:B10). With no quotes around E1, I get an error message, with quotes I get 0 regardless of whats in columns A & B. Seems like there must be a simple answer. Thanks 
|
|
#2
September 23rd, 2004, 01:34 AM
|
|||
|
|||
|
=sumif(A1:A10,""&E1,B1:B10)
may work for you. Darby wrote: Is there a way to use the sumif formula so that the criteria is a a particular cell. Ideally I'd like the formula =sumif(A1:A10,E1,B1:B10). With no quotes around E1, I get an error message, with quotes I get 0 regardless of whats in columns A & B. Seems like there must be a simple answer. Thanks -- Dave Peterson
|
|
#3
September 23rd, 2004, 01:17 PM
|
|||
|
|||
|
Thanks, it works fine. Don't quite understand why but it
does. Thanks again -----Original Message----- =sumif(A1:A10,""&E1,B1:B10) may work for you. Darby wrote: Is there a way to use the sumif formula so that the criteria is a a particular cell. Ideally I'd like the formula =sumif(A1:A10,E1,B1:B10). With no quotes around E1, I get an error message, with quotes I get 0 regardless of whats in columns A & B. Seems like there must be a simple answer. Thanks -- Dave Peterson .
|
|
#4
September 24th, 2004, 04:04 AM
|
|||
|
|||
|
Inside the quotes: "E1", you'd be really checking to see if it was larger than
the characters E1--not what was in E1. ""&E1 just concatenates what's in E1 with that greater than sign: "6" (if E1=6) Darby wrote: Thanks, it works fine. Don't quite understand why but it does. Thanks again -----Original Message----- =sumif(A1:A10,""&E1,B1:B10) may work for you. Darby wrote: Is there a way to use the sumif formula so that the criteria is a a particular cell. Ideally I'd like the formula =sumif(A1:A10,E1,B1:B10). With no quotes around E1, I get an error message, with quotes I get 0 regardless of whats in columns A & B. Seems like there must be a simple answer. Thanks -- Dave Peterson . -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using the contents of a cell in a formula | claytorm | General Discussion | 1 | July 10th, 2004 04:49 PM |
| copying and controling a formula cell to cell | kevin | Worksheet Functions | 5 | February 13th, 2004 01:26 PM |
| How to lock one cell in formula? | Worksheet Functions | 2 | December 26th, 2003 01:22 PM | |
| Placing a formula into a cell through VBA code | Michelle Hillard | Worksheet Functions | 1 | December 24th, 2003 11:41 PM |
Linear Mode
