| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUMPRODUCT(--($D$5:$D$57=$D121),--(G$5:G$57))
I'm stuck using XL 2000 and so can't figure out why this formula is not
calculating. D5:D57 are expense codes, formatted as General. These expense codes are 5 digits long, but are NOT formatted as numbers. D121 is an expense code, formatted as General. G5:G57 are dollar values, formatted as Accounting. The value returned should be $1,203,201 but $0 is being returned. Does XL 2000 have a SUMPRODUCT limitation that I'm unaware of? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sumproduct | Excel Discussion (Misc queries) | |||
| Sumproduct | Excel Worksheet Functions | |||
| Sumproduct | Excel Discussion (Misc queries) | |||
| Like Sumproduct, But Different | Excel Worksheet Functions | |||
| Sumproduct Help | Excel Worksheet Functions | |||
Threaded Mode
