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

  • Thread starter Thread starter JPD
  • Start date Start date
J

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 .......
 
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)
 
Hi

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

--
Regards
Roger Govier

JPD said:
=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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top