Thread: DSUM with columns as records and rows as values

Hello,

I have the following problem:

I used the DSUM formula to sum the costs between a range of dates (condition).
I have the dates in rows (records) and the costs for each date in columns(values).
Now I have changed the dates to columns (records) and the costs to rows (values).

The conditions remains the same >= Date1 and <=Date2.

What I would like to know if there is an alternative to DSUM that would look progressively at the rows and not at the columns for the Values and Rows.
Sort of I have the DSUM as a VLOOKUP and would need a DSUM for HLOOKUP.
I know they are different functions but it is just to give you the idea of what I need.

I would very much appreciate it if anyone could help me with this issue.

I found a way to do this so I will post it.
Unfortunately I didn't get a reply here.

I calculated the sum of all values up to the day I needed, added it to the sum of all the values after the last day of my range that I needed to calculate and subtracted the sum of all the data available without any restrictions.

Example:
=sumif(A1:E1,>date1,A2:E2)+sumif(A1:E1,<=date2,A2:E2)-Sum(A2:E2)

A1:E1 – all the dates
A2:E2 – all the values
Chance date 1 and date 2 with the restrictions that you need, the first day o the range and the last day of the range you need.

Hope it helps someone.

After all this was the hard way.
A simple "SUMIFS" would have done the job.

=SUMIFS(A1:E1,>date1,A2:E2,<=date2,A2:E2)

A1:E1 – all the dates
A2:E2 – all the values
Change date 1 and date 2 with the restrictions that you need, the first day o the range and the last day of the range you need.