{=SUMPRODUCT(1/COUNTIF(A8:A18,A8:A18))}
A | ||
| Name | Amount | |
| a | £ 80.00 | |
| b | £ 33.00 | |
| c | £ 56.00 | |
| d | £ 88.00 | |
| a | £ 80.00 | |
| f | £ 60.00 | |
| g | £ 55.00 | |
| a | £ 80.00 | |
| i | £ 90.00 | |
| j | £ 96.00 | |
| a | £ 80.00 | |
No comments:
Post a Comment