| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help regarding 'IF' function in Excel
Thanks JonR that helped.....
"JonR" wrote: It looks like you're trying a conditional sum to evaluate an array. Did you try holding down the Ctrl-Shift keys when you press <Enter? Your formula will be enclosed in brackets: {= SUM(IF(D2:D2263=1,IF($H$1:$H$2263=E2269,IF($K$1:$K $2263=G2269,IF($E$1:$E$2263="A",$C$2:$C$2263,0),0) ,0),0))} "Mayur Godbole" wrote: Thank You Guys Im still trying to figure it out and keep getting an error. I have tried using the solutions you have provided but keep getting an error. Thank you anyways. "Mayur Godbole" wrote: I am using excel for preparing a schedule of Doors. For sorting the data i have used the following formula SUM(IF(D2:D2263=1,IF($H$1:$H$2263=E2269,IF($K$1:$K $2263=G2269,IF($E$1:$E$2263="A",$C$2:$C$2263,0),0) ,0),0)) which returns a #Value Error. If i evaluate this formula through Insert<Fuction, i am getting the desired result, if i evaluate the formula through formula auditing i get the error, is this a bug in the programme. The problem is in the if statement, Excel is not evaluating the condition D2:D2263=1 as a whole but is only evaluating d2:d2263 Any help would be greatly appreciated. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
| How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
| Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Threaded Mode
