Hi Carim,

The sumproduct() function doesnt do what I need,

What I'm basically after is summing various values from cells in
column G based on the criteria of
value in same row from column A AND Column C AND Column H so for
example

when A1 is 4 AND C1 is Test AND H1 is Consumables the value of G1 is
added to a variable.

I then need to loop through to the next row and perform the same
check, if the same criteria are matched then I need to add the value
from G2 to the variable.

When I have looped through the rows I can then put the total (that
might be something along the lines of the sum of (G1, G2, G4, G100)
into a cell on the spreadsheet so that I can use it elsewhere. I seem
to be able to manage everything apart from actually matching the
criteria.

Regards

J

On 31 Aug 2006 01:44:10 -0700, "Carim" wrote:

Hi,

take a look at the function Sumproduct() ...
it will easily fix your problem ...

HTH
Cheers
Carim