SUMIFS

[madocar]

Hi,

is there any way how to use sumifs function with 2 conditions?
First condition is easy, second one is about occurence text in string.
I know there is a way to create a help column (ISNUMBER(FIND(.... ), but anyway is there any way how to do that using one formula?


Excel file in attachment

 

[madocar]

Excel file in attachment

 

[Nebu]

Hi:

formula in yellow cells.

Thanks

 

[madocar]

Thanks Nebu, it is close but does not fit required values.

So basically, there are two conditions. These must match simultaneously (AND=)
first condition = is "bluzky" in column A:A
second condition = is there any occurence of "param1" in column B:B etc.

 

[Somendra Misra]

Hi,

Try below formula:

=SUMIFS($C$2:$C$8,$A$2:$A$8,E2,$B$2:$B$8,"*"&F2&"*")
E2=bluzky
F2=param1

Regards,

 

[madocar]

Thanks Nebu, you showed me the way how to go on!
Somendra Misra = excelent!!!

Thanks a lot both of you