LinkBack URL
About LinkBacks
someone receommended me this statement
=SUMPRODUCT(SP-B!$M$12:$M$10000,(SP-B!$E$12:$E$10000="")+(YEAR(SP-B!$E$12:$E$10000)=2006))
it works great but i'm trying to remove the part in bold. how do i do that and keep the right syntax?
thank you
someone receommended me this statement
=SUMPRODUCT(SP-B!$M$12:$M$10000,(SP-B!$E$12:$E$10000="")+(YEAR(SP-B!$E$12:$E$10000)=2006))
it works great but i'm trying to remove the part in bold. how do i do that and keep the right syntax?
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks