Changing Formula

C

cagataybaser

New member
Joined
Aug 14, 2014
Messages
13
Reaction score
0
Points
0
Hi everyone,
I have a formula like this
Code: 
=$A$185+SUMPRODUCT($B$14:$B$160;AF14:AF160)+SUMIF(AF14:AF160;"<1")
and I need to change "$A$185" part to lastrow in column A
I will be really glad if you help me.
 
Try

=LOOKUP(99^99,$A:$A)+SUMPRODUCT($B$14:$B$160;AF14:AF160)+SUMIF(AF14:AF160;"<1")
 
You must log in or register to reply here.
Back
Top