Changing Formula

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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try

=LOOKUP(99^99,$A:$A)+SUMPRODUCT($B$14:$B$160;AF14:AF160)+SUMIF(AF14:AF160;"<1")
 
Top