SUMIF

[Nath]

HI,

I have two criteria that i wish to use within the SUMIF
function, is this possible. I have both a Product Name
and a Week number. Week number is column f and product is
column H, the value is column I. The week # is in cell
a1, the products are in a list from a2 downwards.

TIA

Nath.

 

[Helen Trim]

You can't have 2 criteria in a sumif function. One way
round this is to use an AND function or OR function in a
separate column to test both criteria. This will then
have true or false on each line. Then you can use this
column as your criteria range.

For example, if you want to sum column C where column A
equals "Fred" and column B is greater than 10, then in
column D have the function:
=AND(A2="Fred",B2>10)

Then the sum is given by:
=SUMIF(D,TRUE,C:C)

Hope this helps,
Helen