Hello Everyone,
If I have a formula SUMIF(A1:A4,"<10000,B40:B50) and I don't want a static test.
Instead of "<10000", I want <c5, and the value will change.
Any ideas on a formula?
Thanks Kindly
Kerrie
Results 1 to 3 of 3
-
2 Star Lounger
- Join Date
- Apr 2001
- Location
- Melbourne, Australia
- Posts
- 118
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-10-23 04:42SUMIF and cell references (Excel 2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2002-10-23 05:24Re: SUMIF and cell references (Excel 2000)
Replace "<10000" (I assume the missing closing " was just a typo) by "<"&C5.
Note: Since your criteria range A1:A4 consists of only 4 cells, the sum will be evaluated over B40:B43; the rest (B44:B50) will be ignored.
-
2 Star Lounger
- Join Date
- Apr 2001
- Location
- Melbourne, Australia
- Posts
- 118
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-10-23 05:59Re: SUMIF and cell references (Excel 2000)
Thank you Hans, it worked [img]/forums/images/smilies/smile.gif[/img]
