Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My Excel formala is not returning the correct value
This is th formula:
=SUM(IF(Entry_Day_Range=1,IF($H$7:$H$300=GandA_Lab el,$I$7:$I$300,0),0)) only 1 value in the range fits criteria, but the sum of all values is being returned. When I check the formula in the functions window, it shows the correct results, but the cell does not reflect that. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My Excel formala is not returning the correct value
You need to enter the formula with ctrl + shift & enter
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "boothguy" wrote in message ... This is th formula: =SUM(IF(Entry_Day_Range=1,IF($H$7:$H$300=GandA_Lab el,$I$7:$I$300,0),0)) only 1 value in the range fits criteria, but the sum of all values is being returned. When I check the formula in the functions window, it shows the correct results, but the cell does not reflect that. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My Excel formala is not returning the correct value
Amazing - why did that work, and how do I know when to use this in the future?
Thanks you very much!!! "Peo Sjoblom" wrote: You need to enter the formula with ctrl + shift & enter -- Regards, Peo Sjoblom http://nwexcelsolutions.com "boothguy" wrote in message ... This is th formula: =SUM(IF(Entry_Day_Range=1,IF($H$7:$H$300=GandA_Lab el,$I$7:$I$300,0),0)) only 1 value in the range fits criteria, but the sum of all values is being returned. When I check the formula in the functions window, it shows the correct results, but the cell does not reflect that. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My Excel formala is not returning the correct value
Lookup array formulas in help
Peo "boothguy" wrote in message ... Amazing - why did that work, and how do I know when to use this in the future? Thanks you very much!!! "Peo Sjoblom" wrote: You need to enter the formula with ctrl + shift & enter -- Regards, Peo Sjoblom http://nwexcelsolutions.com "boothguy" wrote in message ... This is th formula: =SUM(IF(Entry_Day_Range=1,IF($H$7:$H$300=GandA_Lab el,$I$7:$I$300,0),0)) only 1 value in the range fits criteria, but the sum of all values is being returned. When I check the formula in the functions window, it shows the correct results, but the cell does not reflect that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
What is correct URL for down loading stock quotes in Excel 2000? | Excel Discussion (Misc queries) | |||
How do I get the date correct in excel 2000 on a chart? | Charts and Charting in Excel | |||
How do I put in more than 7 validations in IF FORMALA in EXCEL | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |