If statement- formula

  • Thread starter Thread starter Julz
  • Start date Start date
J

Julz

Well I'm stumped again.

If close!ag2:ag19999 contains "xyz" enter contents of close!ag2:ag19999,
otherwise enter contents of close!ae2:ae19999

thanx,
~Julz
 
Hi
what do you mean with 'enter contents'?. Do you want to add them? If
yes try
=SUMIF(close!ag2:ag19999,"xyz",close!ag2:ag19999)+SUMIF(close!ag2:ag199
99,"<>xyz",close!ae2:ae19999)
 
That's it!! Thanx!!

Just when I think I know what I'm doing...
I can't figure this out.

if D=N then count k<16
 
This is what I was trying to do. Seems we had already gone down that
road. I'm just battin' a thousand today. ;)

=SUMPRODUCT(--(open!D2:D19000="n"),--(open!K2:K19000<16))

Thanx as always and please forgive my redundancy. I'm in over my head
and I know it.

~Julz
 
Hi Julz..........

Considering D, N, and K are Rangenames,
Maybe..........
=IF(D=N,COUNTIF(K,"<16"),"")

Vaya con Dios,
Chuck, CABGx3
 
Back
Top