View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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 . . .