LinkBack URL
About LinkBacks
I'm trying to do the sumproduct vertically and horizontaly but can't get it to work. Any ide how to fix this?
=SUMPRODUCT(--(CXV!$A$6:$A$12=$A7),--(CXV!$P$5:$AA$5=$C$5),CXV!$P$7:$P$1
Obviously the problem is with middle part.
Thank you
I'm trying to do the sumproduct vertically and horizontaly but can't get it to work. Any ide how to fix this?
=SUMPRODUCT(--(CXV!$A$6:$A$12=$A7),--(CXV!$P$5:$AA$5=$C$5),CXV!$P$7:$P$1
Obviously the problem is with middle part.
Thank you
Last edited by jimstrongy; 03-21-2012 at 06:00 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks