How to calculate combinations

Hi,

I require a way to calculate the number of combinations of different numbers from 3 separate cells.

For example:

2,4
10,14
3,6,15

The number of combinations here is 2x2x3 = 12

I did use =SUM(LEN(B20)-LEN(SUBSTITUTE(B20,{1,2,3,4,5,6,7,8,9,0},))) but it takes a double figure number as 2 numbers.

Any help would be appreciated.

Thanks in advance!

Try this instead:

=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,",","")))+1

Thank you Ali.. perfect!!

or
=SUMPRODUCT((MID(B20,ROW($1:$99),1)=",")*1)+1