Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to show =500 but +<1000 in one column
I can find a formula to calculate one, but not both - can anyone help? Many
thanks. -- In need of help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to show =500 but +<1000 in one column
What do you mean to 'show' numbers? add them up?
Try this =SUMPRODUCT((A1:A20=500)*(A1:A20<=1000)*(A1:A20)) Mike "rahji" wrote: I can find a formula to calculate one, but not both - can anyone help? Many thanks. -- In need of help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to show =500 but +<1000 in one column
Your question is open to some interpretation. You may want something like this
=IF(AND(A1=500,A1<1000),A1,NA()) -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "rahji" wrote: I can find a formula to calculate one, but not both - can anyone help? Many thanks. -- In need of help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to show =500 but +<1000 in one column
Thanks Mike - I have a list of numbers, and I want to have a total of numbers
over 500 but less than 1000. -- In need of help. "Mike H" wrote: What do you mean to 'show' numbers? add them up? Try this =SUMPRODUCT((A1:A20=500)*(A1:A20<=1000)*(A1:A20)) Mike "rahji" wrote: I can find a formula to calculate one, but not both - can anyone help? Many thanks. -- In need of help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for increasing a result to the next highest 1000 | New Users to Excel | |||
copy formula down 1000,s of lines | Excel Worksheet Functions | |||
Duplicate a Formula in 1000 Spreadsheets | Excel Programming | |||
1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
Need macro to updated column C's width on 1000+ workbooks. | Excel Programming |