No. of Recipients (In Excel A3)
=SUMPRODUCT((A5:A200<>"")/COUNTIF(A5:A200,A5:A200&""))
No. of Invoices (In Excel C3)
=SUMPRODUCT((C5:C200<>"")/COUNTIF(C5:C200,C5:C200&""))
Total invoice value (In Excel E3)
=SUMPRODUCT(1/COUNTIF(C5:C200,C5:C200&""),E5:E200)
Total Taxable value (In Excel L3)
=SUM(L5:L200)
Example
In this Video we will see Important Formula that are used in GSTR 1 Offline tool
