LinkBack URL
About LinkBacks
if that was the case just sum (b1,n1,z1) unless there are -ve values
=SUM(IF(B1>0,B1,0),IF(N1>0,N1,0),IF(Z1>0,Z1,0))
palmettos sums up anything in range b1:z1
also
=SUM(SUMIF(INDIRECT({"b1","n1","z1"}),">0")
if that was the case just sum (b1,n1,z1) unless there are -ve values
=SUM(IF(B1>0,B1,0),IF(N1>0,N1,0),IF(Z1>0,Z1,0))
palmettos sums up anything in range b1:z1
also
=SUM(SUMIF(INDIRECT({"b1","n1","z1"}),">0")
Last edited by martindwilson; 12-16-2009 at 07:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks