J
joec
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.
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.