Nel post
*Debbie* ha scritto:


"Franz Verga" wrote:

Nel post
*Marcelo* ha scritto:

Hi Debbie,

if on the column h you have figures, try to use sumproduct as

sumproduct(--(c7:c20="client")*(d7:d20="project"),(h7:h20))

Hi Marcelo,

In this case you don't need "--". You can use sumproduct function in
may ways:

sumproduct(--(c7:c20="client"),--(d7:d20="project"),(h7:h20))

or

sumproduct((c7:c20="client")*(d7:d20="project"),(h 7:h20))

or also

sumproduct((c7:c20="client")*(d7:d20="project")*(h 7:h20))

But last one could produce errors if (h7:h20) contain a single text
entry.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Marcelo and Franz,

Thanks but these didn't help.
Any other suggestions?


Why didn't help? What is the result?


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy