Totals f(x) text values in multiple columns and cells
Try something like this:
=SUMPRODUCT(--(A1:A10="A"),--(B1:B10="B"),--((C1:C10="A")+(C1:C10="B")+(C1:C10="C")),(D1:D10))
HTH,
Elkar
"jkl" wrote:
Text data is listed in column A, B, and C. Numerical data in column D. I
need to total the values of the numbers in column D for those instances in
which column A has a particular text value, column B has a particular text
value, AND column C has any one of three text values.
Thanks in advance . . .
|