Excel formula for Create List more than 0 value

Dear Experts,

Please find here attached sample workbook, where i am expecting the total count in cell F3 as 4 because there are 4 Unique Customers where the value of the sales either in column B or C is more than 0. Likewise expecting the output in cell G3 as unique customer names because the value in column B or C value is more than 0 and in cell H2 and I2 the total sales value from column B and C for the customer.

I hope i have clarified my expectations as well I have given my expected output from column F to I based on data from column A to C. Request to you please do not hesitate to revert back in case of any further clarification.

Thank you so much for your precious phase and valuable support.

Sincerely,

Neilesh

	F	G	H	I
1	Expected Output
2	Count	Customer Name	CRM	Android
3	4	Customer 01	550	500
4		Customer 09	4150	3850
5		Customer 22	3996	0
6		Customer 25	0	4853.226

F3=SUM(IF(FREQUENCY(IF(A2:A100<>"",IF(B2:C100>0,MATCH(A2:A100,A2:A100,0))),ROW(A2:A100)-ROW(A2)+1),1))

Control+shift+enter

G3=IFERROR(INDEX($A$2:$A$100,SMALL(IF(FREQUENCY(IF($A$2:$A$100<>"",IF($B$2:$C$100>0,MATCH($A$2:$A$100,$A$2:$A$100,0))),ROW($A$2:$A$100)-ROW($A$2)+1),ROW($A$2:$A$100)-ROW($A$2)+1),ROWS($A$2:A2))),"")

Control+shift+enter

Copy down

H3=IF($G3<>"",SUMIF($A$2:$A$100,$G3,B$2:B$100),"")

Copy across and down

Thank you so much Dear Exper CARACALLA. Your provided solution worked like a charm. Thank you so much once again.