How to Get Number of Invoices each Vendor

[aamirgee]

Hello! I want to count total Number of Invoices for each Vendors & also want to count how many invoices have payment method Cash, Transfer and Others.

Help me. (This is my 1st Question)

 

[Peter_SSs]

Are you using Excel 365?

 

[aamirgee]

Are you using Excel 365?

No I am using Office 2021 Pro + LTSC

 

[Peter_SSs]

No I am using Office 2021 Pro + LTSC

My solution suggestion was based on the information available to me which was ..

 

[aamirgee]

My solution suggestion was based on the information available to me which was ..

View attachment 118482

This is my Excel Ver.

 

[Peter_SSs]

As I indicated, my suggestion was for Excel 365. It won't work in other versions.

 

[aamirgee]

As I indicated, my suggestion was for Excel 365. It won't work in other versions.

OK, Thanks for Helping me. Can anyone else help me in this issue ??

 

[Peter_SSs]

Perhaps you should update your forum profile to show that you are using Excel 2021 so helpers don't continue to make incorrect assumptions about what functions and resources you have available to you.

 

[aamirgee]

Unfortunetly i have installed 2 versions.

 

[Peter_SSs]

Unfortunetly i have installed 2 versions.

Two version are fine, but neither of them is 365 as shown in your profile.

 

[aamirgee]

View attachment 118427
Formula in J1

=LET(ven,G2:G13,inv,A2:A13,met,H2:H13,x,UNIQUE(ven),zinv,BYROW(x,LAMBDA(ra,COUNTA(UNIQUE(FILTER(inv,ven=ra))))),zcash,BYROW(x,LAMBDA(ra,COUNTA(UNIQUE(FILTER(inv,(ven=ra)*(met="cash")))))),ztfr,BYROW(x,LAMBDA(ra,COUNTA(UNIQUE(FILTER(inv,(ven=ra)*(met="transfer")))))),hdr,{"Vendor","Invoice","Cash","Transfer"},VSTACK(hdr,HSTACK(x,zinv,zcash,ztfr)))

your Idea is good but not working to my excel sheet