Sum of cost of column depending on row values

[phb_abs]

Hi guys,

I would like a little help on one more i've been baffled by for the last two days if you could please.

If the column A is not blank, and column B contains the word 'assigned', could it sum up the value of those cells in column C. Basically trying to get the cost of works that has currently been assigned to someone.

issue 1	assigned to x	£10
issue 2	resolved	£20
issue 3	assigned to y	£15
issue 4		£80

This should therefore add up to £35.

The problem i'm having is the use of multiple if functions and how to make the formula sum up specific cells.

Any help greatly appreciated,

Thanks
Abs

[zbor]

Try

Please Login or Register  to view this content.

However, result should be 25 (not 35): 10+15. Right?

[Debraj Roy]

try this..

=sumifs(c:c,a:a,"<>",b:b,"*Assigned*")

[phb_abs]

Woops yes £25. Great, worked a treat zbor.

Thanks Debraj Roy too.

Cheers