How to make a SumIf range not a range ... but a sum of specific cells

[JPD]

=SUMIF(D3,AL3,"=H3+J3+L3+N3+P3+R3+T3+V3+X3+Z3+AB3+AD3")

Here is what I am trying to do: If D3 = AL3 then I want it to return
the sum of H3+J3+L3+N3+P3+R3+T3+V3+X3+Z3+AB3+AD3

I know it is something simple I am missing .......

 

[Bob I]

Just use If()

=if(d3=al3,H3+J3+L3+N3+P3+R3+T3+V3+X3+Z3+AB3+AD3,0)

 

[T. Valko]

Another way...

Assuming that if D3 does not equal AL3 then you want a result of 0.

=(D3=AL3)*SUM(H3,J3,L3,N3,P3,R3,T3,V3,X3,Z3,AB3,AD3)

 

[Roger Govier]

Hi

Another variant
=IF(D3=AL3,SUMPRODUCT(--(MOD(COLUMN(H3:AD3),2=0),H3:AD3),0)

--
Regards
Roger Govier

=SUMIF(D3,AL3,"=H3+J3+L3+N3+P3+R3+T3+V3+X3+Z3+AB3+AD3")

Here is what I am trying to do: If D3 = AL3 then I want it to return
the sum of H3+J3+L3+N3+P3+R3+T3+V3+X3+Z3+AB3+AD3

I know it is something simple I am missing .......

__________ Information from ESET Smart Security, version of virus
signature database 4836 (20100204) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4836 (20100204) __________

The message was checked by ESET Smart Security.

http://www.eset.com