LinkBack URL
About LinkBacks
since
A1 =SUMIF(CHR!$D$17:$D$5000,C10,CHR!$K$17:$K$5000) and
A2 =SUMIF(CHR!$D$17:$D$5000,C10,CHR!$L$17:$L$5000)
will return a 0 if nothing
then
=if( and( a1 =0, a2 = 0), 0, if( a2> 0, a2, a1))
since
A1 =SUMIF(CHR!$D$17:$D$5000,C10,CHR!$K$17:$K$5000) and
A2 =SUMIF(CHR!$D$17:$D$5000,C10,CHR!$L$17:$L$5000)
will return a 0 if nothing
then
=if( and( a1 =0, a2 = 0), 0, if( a2> 0, a2, a1))
Last edited by martindwilson; 11-18-2008 at 05:09 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks