Help require with excel formulas

Geraldineie84 

To calculate daily totals of card payments from your report, you can use the SUMIFS formula in Excel. Here is how you can do it:

Assuming your dates are in column A and amounts are in column B, and your data starts from row 2, you can follow these steps:

1. Insert a new column next to the "Amounts" column (let's say it's column C) and enter the formula below in the first cell (cell C2):

=SUMIFS($B$2:$B$17001,$A$2:$A$17001,A2)

This formula sums the amounts in column B where the date in column A matches the date in the current row.

1. Drag the formula down to apply it to all rows in column C.
2. Now, column C will show the daily totals of card payments corresponding to each date.

Alternatively, if you prefer a pivot table to summarize the data, you can follow these steps:

1. Select your data range (both columns) including headers.
2. Go to the "Insert" tab in the Excel ribbon.
3. Click on "PivotTable" and choose the location where you want to place the pivot table.
4. In the PivotTable Field List, drag the "Dates" field to the "Rows" area, and the "Amounts" field to the "Values" area.
5. By default, the pivot table will show the sum of amounts by dates. Right-click on any date in the pivot table, select "Group", and choose "Days" to group the dates by days.
6. Now, the pivot table will display the daily totals of card payments.

These methods should help you obtain the daily totals of card payments from your report. Choose the one that suits your preference and reporting needs.

If you need more help, please include the following info to help others answer your question:

Welcome to your Excel discussion space!