LinkBack URL
About LinkBacks
Hi All
See attached file, need same technique but using sumproduct instead of sumifs .
need this as certain of my peers are using excel 2003.
Thanks if any anyone can help.
Hi All
See attached file, need same technique but using sumproduct instead of sumifs .
need this as certain of my peers are using excel 2003.
Thanks if any anyone can help.
You might also want to check the differences in tables between 2003 and 2007.
T2 =SUMPRODUCT(Table2[[Amount]:[Amount]], --(Table2[[Invoice ]:[Invoice ]]=$Q2), --(Table2[[Origin]:[Origin]]=T$1))
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Hi Thanks , save file in excel 2003 format,however could advise for column amount how to use sumproduct according invoices
I'm don't think that XL2003 had structured tables, so put this formula in T2:
=SUMPRODUCT($L$2:$L$428,($B$2:$B$428=$Q2)*($M$2:$M$428=T$1))
then copy across and down. Don't forget to save the file as a 97-2003 compatible (i.e. with .xls extension).
Hope this helps.
Pete
Hi
Try your formula , works very well,but could you help me for column R Amount with sumproduct formula
Not sure who you are addressing that last comment to.
Pete
Sorry it was addressed to Pete and Ben_Hensel for column amount a solution formula for column Amount using sumproduct
Maybe a pivot table is an alternative way.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Hi
Try your method , not well aquainted with pivot table, try by myself well very good this method
Thanks
It's really easy?
existing:
Sumproducts notation:=SUMIFS(Table2[Amount],Table2[[Invoice ]],Q2)
=SUMPRODUCT(Table2[Amount], --(Table2[[Invoice ]]=Q2))
HI BEN
Do agree I feelbut at least I have learned a bit more on sumproduct.
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks