Hi
I want to check condition of 3 columns in my sheet and then add the count of
column and also sum the values in that column
I am using this formula, but it does not work.
=COUNT(IF((TRIM('IL'!$C$4:$C$196)="cp")*(TRIM('IL' !$G$4:$G$196)="ab")*(TRIM('IL'!$L$4:$L$196)="aa"), 'IL'!$Q$4:$Q$196))
=sum(IF((TRIM('IL'!$C$4:$C$196)="cp")*(TRIM('IL'!$ G$4:$G$196)="ab")*(TRIM('IL'!$L$4:$L$196)="aa"),'I L'!$Q$4:$Q$196))
Please advise
Thanks