| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question #2 of ???
Connie Martin wrote:
Sorry. This gives me #VALUE!. Connie "Infinitogool" wrote: Hi Connie Try in E10 =SUMPRODUCT((A39:A1000=A10)*J39:J1000) Regards, Pedro J. That looks like an array formula. Try entering the formula by pressing Ctrl + Shift + Enter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| QUESTION | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| an if question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Threaded Mode
