Consolidate Countif Formula

[farhadj]

Good Day

I have this formula which works, however I would like to know if there is a way of consolidating the formula into one

=COUNTIFS(Sheet4!$B:$B;"Laptop";Sheet4!$AM:$AM;"*DBN*")+COUNTIFS(Sheet4!$B:$B;"Laptop";Sheet4!$AM:$AM;"*OVP*")+COUNTIFS(Sheet4!$B:$B;"Laptop";Sheet4!$AM:$AM;"*ATH*")+COUNTIFS(Sheet4!$B:$B;"Laptop";Sheet4!$AM:$AM;"*FOR*")

I find the above formula cumbersome to work with

Thanks

[AliGW]

You could try this:

=SUM(COUNTIFS(Sheet4!$B:$B;"Laptop";Sheet4!$AM:$AM;{"*DBN*","*OVP*","*ATH*","*FOR*"}))

[farhadj]

Hi AliGW

Tried your suggestion, unfortunately did not work

[AliGW]

Define "did not work", please. In what way? Error message? Incorrect result?

[farhadj]

Dear AligGW

My sincere apologies, your formula worked

Thanks a million

[AliGW]

Ah, fab!!! Thanks for letting me know.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.