multiple arguments in 'countif'

Topics: User Forum
Mar 12, 2012 at 4:43 PM

Hi all,

I have the following line:

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($sp,$z1, '=SUM(COUNTIF('.$colums[$colum].$start.':'.$colums[$colum].$ende.',"s1"))');

and I need not only "s1" as search argument but something like that (original excel-formula):

=SUM(CONTIF(C5:C21;{"f1"."f2"."f3"."f4"."m1"."m2"."m3"."m4"."s1"."s2"."s3"."hl1"."hl2"."hl6"}))

How to realize? I did not find a hint in the discussions.

Regards

Martin