# Sum values in a table by Date and repeating values down column A

1. ## Sum values in a table by Date and repeating values down column A

Hi,

If you have a list of values in a table with dates across the top row and repeating values down column A (eg, Mar, Dec, Oct, Nov, Mar, Oct) what functions do you use to be able to get the sums for each date and month in another table?
I thought it might be INDEX and MATCH but all the examples I have seen are so confusing it would be impossible to actually work out how to use these.

Thanks very much

Dave

2. ## Re: Sum values in a table by Date and repeating values down column A

It would be a SUMPRODUCT construct, but without seeing the data, I can't elaborate. Please upload a sample workbook.

3. ## Re: Sum values in a table by Date and repeating values down column A

Hi, I have been trying to figure out how to attach a sample. Its certainly well hidden.

4. ## Re: Sum values in a table by Date and repeating values down column A

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

5. ## Re: Sum values in a table by Date and repeating values down column A

10-Nov-18 17-Nov-18 24-Nov-18 1-Dec-18 8-Dec-18
Feb 1 4 1 4 1
Apr 4 6 4 6 4
Jan 5 2 5 2 5
Mar 8 9 8 9 8
Feb 2 0 2 0 2
Mar 8 6 8 6 8
Jan 2 0 2 0 2
Apr 7 3 7 3 7

Totals
10-Nov-18 17-Nov-18 24-Nov-18 01-Dec-18 08-Dec-18
Jan
Feb
Mar
Apr

I need the Sums not Products. Thanks

OK, thanks

7. ## Re: Sum values in a table by Date and repeating values down column A

In B15 copied across and down:

=SUMPRODUCT((\$A\$2:\$A\$9=\$A15)*(\$B\$1:\$F\$1=B\$14)*\$B\$2:\$F\$9)

8. ## Re: Sum values in a table by Date and repeating values down column A

Thanks very much AliGW!

9. ## Re: Sum values in a table by Date and repeating values down column A

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