| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM IF
I would like to sum values within a certain range located in a separate
worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM IF
=SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source
$50MM'!B1:B241,"10000") will count from 5000 to 10000 -- Regards, Peo Sjoblom "Stella" wrote in message ... I would like to sum values within a certain range located in a separate worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM IF
One way:
=SUMIF('Data Source $50MM'!B1:B2240,"=5000") - SUMIF('Data Source $50MM'!B1:B241,"10000") (i.e., subtract values 10K from all values =5K) Another: =SUMPRODUCT(--('Data Source $50MM'!B1:B2240=5000), --('Data Source $50MM'!B1:B2240<=10000), 'Data Source $50MM'!B1:B2240) In article , Stella wrote: I would like to sum values within a certain range located in a separate worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM IF
I cannot thank you enough. Your quick accurate response is so greatly
appreciated. "JE McGimpsey" wrote: One way: =SUMIF('Data Source $50MM'!B1:B2240,"=5000") - SUMIF('Data Source $50MM'!B1:B241,"10000") (i.e., subtract values 10K from all values =5K) Another: =SUMPRODUCT(--('Data Source $50MM'!B1:B2240=5000), --('Data Source $50MM'!B1:B2240<=10000), 'Data Source $50MM'!B1:B2240) In article , Stella wrote: I would like to sum values within a certain range located in a separate worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM IF
Can you help me one more time? I need to count the information in the same
ranges, but changing to countif from(sumif) doesn't work. "Stella" wrote: I would like to sum values within a certain range located in a separate worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM IF
What does "doesnt' work" mean? COUNTIF() and SUMIF() should be
interchangeable as long as you have only two arguments. What formula did you end up using? It would be helpful to reply to *that* post, rather than the original one. In article , Stella wrote: Can you help me one more time? I need to count the information in the same ranges, but changing to countif from(sumif) doesn't work. "Stella" wrote: I would like to sum values within a certain range located in a separate worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM IF
I used the SUMPRODUCT FORMULA BELOW - it worked great to determine Value, but
now I need to count the items. "JE McGimpsey" wrote: One way: =SUMIF('Data Source $50MM'!B1:B2240,"=5000") - SUMIF('Data Source $50MM'!B1:B241,"10000") (i.e., subtract values 10K from all values =5K) Another: =SUMPRODUCT(--('Data Source $50MM'!B1:B2240=5000), --('Data Source $50MM'!B1:B2240<=10000), 'Data Source $50MM'!B1:B2240) In article , Stella wrote: I would like to sum values within a certain range located in a separate worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM IF
One way:
=SUMPRODUCT(--('Data Source $50MM'!B1:B2240=5000), --('Data Source $50MM'!B1:B2240<=10000)) In article , Stella wrote: I used the SUMPRODUCT FORMULA BELOW - it worked great to determine Value, but now I need to count the items. "JE McGimpsey" wrote: One way: =SUMIF('Data Source $50MM'!B1:B2240,"=5000") - SUMIF('Data Source $50MM'!B1:B241,"10000") (i.e., subtract values 10K from all values =5K) Another: =SUMPRODUCT(--('Data Source $50MM'!B1:B2240=5000), --('Data Source $50MM'!B1:B2240<=10000), 'Data Source $50MM'!B1:B2240) In article , Stella wrote: I would like to sum values within a certain range located in a separate worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to $50K Greater than $50K This formula does not work: Can you correct. =SUMIF('Data Source $50MM'!B1:B2240,"=5000") -SUMIF('Data Source $50MM'!B1:B241,"<=10000") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
