Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use sumproduct for this?
is there a way i can use sumproduct or some other formula to data from the
following table for multiple criteria: Associate Month Quest 1 Quest 2 Quest 3 A jan 10 10 10 B jan 9 9 9 B feb 8 8 8 B mar 9 8 8 C jan 7 7 6 C feb 10 10 10 C feb 10 10 10 specifically what i need to do is count the # of times associate C has entries for Feb and return the totl # of all questions and the total of all questions sumed up. The answer for associate C for Feb would be 6 questions for a total of 30. i know this will require 2 different formulas in 2 separate cells, but that is ok. -- joec |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
need some help on sumproduct | Excel Discussion (Misc queries) | |||
SUMPRODUCT--what else?? | Excel Discussion (Misc queries) | |||
Sumproduct? | Excel Discussion (Misc queries) | |||
Like Sumproduct, But Different | Excel Worksheet Functions |