Creating a SUMIF function for changeable data

[js65572]

Hi all,

I wonder if you can help please?

I'm currently trying to create an SUMIFS function across static data in various columns, however the function will kick out next month as one of the columns is likely to change.

Currently I have the below

=SUMIFS(F:F,D:D,"PAY",E:E,"EUR",B:B,"Company")

The item will likely fall out next month as the data in column B is never static (company name will change periodically)

Is there a way I can ensure it's still all added up without being specific to a certain company?

Thank you in advance

 

[Vinoth_Shob]

SUMIFS(F:F,D:D,"PAY",E:E,"EUR",B:B,"*Company*") or

update the company name in one cell then change the formula as SUMIFS(F:F,D:D,"PAY",E:E,"EUR",B:B,"$C$1$*")