| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF data that falls within a range
I am trying to generate a SUMIF statement that looks at the value in COlumn A
to determine if it falls within a range. DATA Probability Fees 100% 100 76% 100 75% 100 55% 100 50% 100 To get the results in the table below my thinking was: For Cell B1 - =SUMIF(A1:a5, .99, b1:b5) For Cell B2 - =SUMIF(A1:a5, .75 AND <1, b1:b5) For Cell B3 - =SUMIF(A1:a5, .50 AND <.76, b1:b5) DESIRED RESULT 100% 100 Confirmed 76% - 99% 100 Probable 51% - 75% 200 Possible The formula for cell B1 works, but I cannot get the range to work in the cells for B2 and B3. Am I making any sense? Much thanks! Race on, John |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF data that falls within a range
Try these:
=SUMIF(A1:A5,"0.99",B1:B5) =SUMIF(A1:A5,"0.75",B1:B5)-SUMIF(A1:A5,"=1", B1:B5) =SUMIF(A1:A5,"0.50",B1:B5)-SUMIF(A1:A5,"=0.76",B1:B5) Format as General or Number -- Biff Microsoft Excel MVP "Racer X" wrote in message ... I am trying to generate a SUMIF statement that looks at the value in COlumn A to determine if it falls within a range. DATA Probability Fees 100% 100 76% 100 75% 100 55% 100 50% 100 To get the results in the table below my thinking was: For Cell B1 - =SUMIF(A1:a5, .99, b1:b5) For Cell B2 - =SUMIF(A1:a5, .75 AND <1, b1:b5) For Cell B3 - =SUMIF(A1:a5, .50 AND <.76, b1:b5) DESIRED RESULT 100% 100 Confirmed 76% - 99% 100 Probable 51% - 75% 200 Possible The formula for cell B1 works, but I cannot get the range to work in the cells for B2 and B3. Am I making any sense? Much thanks! Race on, John |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF data that falls within a range
Rock and Roll - Thank you!
"Racer X" wrote: I am trying to generate a SUMIF statement that looks at the value in COlumn A to determine if it falls within a range. DATA Probability Fees 100% 100 76% 100 75% 100 55% 100 50% 100 To get the results in the table below my thinking was: For Cell B1 - =SUMIF(A1:a5, .99, b1:b5) For Cell B2 - =SUMIF(A1:a5, .75 AND <1, b1:b5) For Cell B3 - =SUMIF(A1:a5, .50 AND <.76, b1:b5) DESIRED RESULT 100% 100 Confirmed 76% - 99% 100 Probable 51% - 75% 200 Possible The formula for cell B1 works, but I cannot get the range to work in the cells for B2 and B3. Am I making any sense? Much thanks! Race on, John |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF data that falls within a range
You're welcome!
-- Biff Microsoft Excel MVP "Racer X" wrote in message ... Rock and Roll - Thank you! "Racer X" wrote: I am trying to generate a SUMIF statement that looks at the value in COlumn A to determine if it falls within a range. DATA Probability Fees 100% 100 76% 100 75% 100 55% 100 50% 100 To get the results in the table below my thinking was: For Cell B1 - =SUMIF(A1:a5, .99, b1:b5) For Cell B2 - =SUMIF(A1:a5, .75 AND <1, b1:b5) For Cell B3 - =SUMIF(A1:a5, .50 AND <.76, b1:b5) DESIRED RESULT 100% 100 Confirmed 76% - 99% 100 Probable 51% - 75% 200 Possible The formula for cell B1 works, but I cannot get the range to work in the cells for B2 and B3. Am I making any sense? Much thanks! Race on, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data that falls within a specific date range? | Excel Worksheet Functions | |||
| Return a value that falls within a defined range | Excel Discussion (Misc queries) | |||
| Checking if a certain day falls in a range | Excel Discussion (Misc queries) | |||
| Data falls in a range +/-1 | Excel Worksheet Functions | |||
| how to count if the value falls between a date range | Excel Discussion (Misc queries) | |||
Linear Mode
