Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### return
Hi all,
When I use the following formula =SUMIF(Oct08!A$2:A$500,A3,Oct08!P$2:P$500)+ SUMIF(Sept08!A$2:A$500,A3,Sept08!P$2:P$500)+ SUMIF(August08!A$2:A$500,A3,August08!P$2:P$500)+ SUMIF(July08!A$2:A$500,A3,July08!P$2:P$500)+ SUMIF(June08!A$2:A$500,A3,June08!P$2:P$500)+ SUMIF(May08!A$2:A$500,A3,May08!P$2:P$500)+ SUMIF(Apr08!A$2:A$500,A3,Apr08!P$2:P$500)+ SUMIF(Mar08!A$2:A$500,A3,Mar08!P$2:P$500)+ SUMIF(Feb08!A$2:A$500,A3,Feb08!P$2:P$500)+ SUMIF(Jan08!A$2:A$500,A3,Jan08!P$2:P$500)+ SUMIF(Dec07!A$2:A$500,A3,Dec07!P$2:P$500)+ SUMIF(Nov07!A$2:A$500,A3,Nov07!P$2:P$500)+ SUMIF(Oct07!A$2:A$500,A3,Oct07!P$2:P$500) I get a return of ###### I use this formula on a previous column and it works perfectly. Any suggestions to why I'm getting this return? Thanks! C. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAX then return value? | Excel Discussion (Misc queries) | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
return value other than #N/A | Excel Worksheet Functions | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions |