Marcelo and Franz,

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



"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