Thread: SUMIF for texts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pieter Pieter is offline
external usenet poster
 
Posts: 23
Default SUMIF for texts

Could anyone help me with this?

I want to create a reference on text (like a SUMIF, but for text)

input: different persons get "x" on CL01, CL02,...
output via formula: OP1,OP2,OP3 listing the column with "x"

A B C D H I J
1 CL01 CL02 CL03 OP1 OP2 OP3
2 John x CL01 - -
3 Hugues x x CL02 CL03 -