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

1. ## 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.

2. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

``Please Login or Register  to view this content.``
You might also want to check the differences in tables between 2003 and 2007.

3. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

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

4. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

Maybe a pivot table is an alternative way.

5. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

Hi
Try your method , not well aquainted with pivot table, try by myself well very good this method

Thanks

6. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

Hi
Try your formula , works very well,but could you help me for column R Amount with sumproduct formula

7. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

Not sure who you are addressing that last comment to.

Pete

8. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

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

9. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

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

10. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

It's really easy?

existing:
``Please Login or Register  to view this content.``
Sumproducts notation:
``Please Login or Register  to view this content.``

11. ## Re: Dynamic sumifs formula to be converted with sumproduct formula for use in excel 2003

HI BEN

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1