Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar to sumproduct...?
Hi there, in Cells a1:z1 i have a list of items, say dogs, cats, mice etc.. (all unique) Cells a2:a100 question numbers (questions 1 to 100) Body of the table (ie a1:z100) contains the results for the questions I want to be able to extract a result. For example what was answer for question 53 for Cats Sumproduct would work if it had to sum, but I dont need to. Is it a combination of h and v lookups? Appreciate assistance!! Regards D *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Similar to Q re 2 Countifs, but Sumproduct doesn't work | Excel Worksheet Functions | |||
sumproduct & Dates & similar Data | Excel Discussion (Misc queries) | |||
Sumproduct & Dates & Similar Data | Excel Worksheet Functions | |||
Help with sumproduct or similar type of function | Excel Discussion (Misc queries) | |||
SUMPRODUCT is OK for a while and later a similar formula returns 0 | Excel Worksheet Functions |