Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

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.

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 method , not well aquainted with pivot table, try by myself well very good this method

Thanks

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

Hi Thanks , save file in excel 2003 format,however could advise for column amount how to use sumproduct according invoices

Sorry it was addressed to Pete and Ben_Hensel for column amount a solution formula for column Amount using sumproduct

HI BEN

Do agree I feel but at least I have learned a bit more on sumproduct.

Thanks for your help