Sumproduct or sumif formula

**vasto** · 08-24-2009, 02:44 PM

a1=good
a2 = 100

b1 = bad
b2 = 50

c1 = good
c2 = 100

would like to sum a2+b2+c2 only if a1,b1,c1 = good.

**NBVC** · 08-24-2009, 02:46 PM

Try

=IF(Countif(A1:C1,"Good")=3,Sum(A2:C2))

**ConneXionLost** · 08-24-2009, 02:47 PM

Try:


=SUMIF(A1:C1,"good",A2:C2)

Cheers,

**vasto** · 08-24-2009, 02:58 PM

sorry my fault

scenairo is all in the same row

a1=good b1=100 c1= bad d1=50 e1=good f1=100

ab ** ef are linked .... would only like to add if the linked cells equal "good".

**daddylonglegs** · 08-24-2009, 03:04 PM

You could still use SUMIF, i.e.

=SUMIF(A1:E1,"good",B1:F1)

although that effectively gives you 5 pairs not 3 [which won't matter if A1, C1 and E1 are always text and B1, D1 and F1 are always numbers]

If you explicitly want three pairs and that's the extent of the range

=(A1="Good")*B1+(C1="Good")*D1+(E1="Good")*F1

**NBVC** · 08-24-2009, 03:03 PM

From your first post, it looks like you only want to add if all 3 are good... is that true? Or you want to add where corresponding value is "Good"?

If the latter:

=SUMIF(B1:F1,"good",A1:E1)

if former:

=IF(COUNTIF(B1:F1,"good")=3,SUM(A1:E1),"")