Posts by AkbarAfshar

Dear Mr.Glenn could you please fix below formula or send me a useful formula instead:

=(SUM(SUMIFS(DIS!C:C,DIS!B:B,{"Taimani","chaman","Khushalkhan"},DIS!E:E,{"Group Loan","GMRB"},DIS!F:F,{"Trade","Services"},DIS!C:C,"<200000")))

Quote from GlennUK

I think this might do it:

Code

=SUMPRODUCT(--NOT(ISNA(MATCH(DIS!B:B,{"Taimani","chaman","Khushalkhan"},0)))*--NOT(ISNA(MATCH(DIS!E:E,{"Group Loan","GMRB"},0)))*--NOT(ISNA(MATCH(DIS!F:F,{"Trade","Trade SS"},0)))*--(DIS!C:C<200000))

and:

Code

=SUMPRODUCT(--NOT(ISNA(MATCH(DIS!B:B,{"Taimani","chaman","Khushalkhan"},0)))*--NOT(ISNA(MATCH(DIS!E:E,{"Group Loan","GMRB"},0)))*--NOT(ISNA(MATCH(DIS!F:F,{"Trade","Services"},0)))*--(DIS!C:C<200000))

I haven't checked them in Excel ... let me know if they work.

Display More

Thank you so much dear Mr. Glenn. It works properly.

Quote from GlennUK

Try this:

Code

=SUMPRODUCT(--NOT(ISNA(MATCH(DIS!B:B,{"Taimani","chaman","Khushalkhan"},0)))*--NOT(ISNA(MATCH(DIS!E:E,{"Group Loan","GMRB"},0)))*--NOT(ISNA(MATCH(DIS!F:F,{"Trade","Trade SS"},0))))

Thank you so much Mr GlennUK , You hit the nail, Now I want to extend my furmula by adding (DIS!C:C,"<200000") so could you please add this part to above formula?

Also I need to fix below formula:

=(SUM(SUMIFS(DIS!C:C,DIS!B:B,{"Taimani","Chaman","Khushalkhan"},DIS!E:E,{"Group Loan","GMRB"},DIS!F:F,{"Trade","Services"},DIS!C:C,"<200000")))

Quote from Carim

Correction below :

Code

=SUM(COUNTIFS(DIS!B:B,{"Taimani","chaman","Khushalkhan"}),COUNTIFS(DIS!E:E,{"Group Loan","GMRB"}),COUNTIFS(DIS!F:F,{"Trade","Trade SS"}))

Thank you for your suggestion but unfortunately it did not work so please instruct me by a new formula of countifs

Attached is for your information

Please correct my formula

=COUNTIFS(DIS!B:B,{"Taimani","chaman","Khushalkhan"},DIS!E:E,{"Group Loan","GMRB"},DIS!F:F,{"Trade","Trade SS"})