Nel post
*Debbie* ha scritto:

I got #Value when I used that code.


Maybe it could be better if you post some data or if you could post a small
example file on www.savefile.com



"Franz Verga" wrote:

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

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy