please help with the formula =sumbycellcolor with multiple criteria

[Vikas_Salvi]

=SUMBYCELLCOLOR(Data!DH:DH,Synopsis!L18,Data!CZ:CZ,Synopsis!N17)

 

[pecoflyer]

Please explain in words what you are trying to do
We have better things to do than guessing...

 

[Vikas_Salvi]

Hi Sir,
I am trying sum of amount by using a formula =sumbycellcolor using a multiple criteria


Please find the sample sheet....

 

[pecoflyer]

AFAIK Sumbycellcolor is part of the Kutools but NOT a native Excel function.
If you have the code of a UDF please post it with your sheet.

 

[Vikas_Salvi]

AFAIK Sumbycellcolor is part of the Kutools but NOT a native Excel function.
If you have the code of a UDF please post it with your sheet.