Hello,

Currently im running an excel program with 4 integrated spreadsheets: CF General, Cash Budget, Master and Daily. Im trying to use the SUMIFS or SUMPRODUCT function to complete a formula in target cell.

Here are my forumlas Ive created trying to complete my objective:

=SUMIFS('CF General'!D3:D46, 'CF General'!A3:A46, CONCATENATE('Cash Budget'!B24), 'CF General'!B3:B46, "Cash")

=SUMPRODUCT(('CF General'!A3:A46='Cash Budget'!B24)*('CF General'!B3:B46="Cash")*('CF General'!D3:D46))

Objective:

On my 'Daily' spreadsheet I would like a cell to add a range of cells only if two conditions are met:

1) Any cell from 'CF General'!A3:A46 equal todays current date, found on 'Cash Budget' cell B24 or another reference cell containing the current date.

IF SO

2) Any cell from 'CF General'!B3:B46 says text string "Cash."

IF BOTH TRUE:

Sum all numbers on 'CF General'!D3:D46 that meet this criteria.
*Note: Other numerical 'credit' entries from other transactions will be in this column as well.

Overall -

Im trying to make it so if I enter a credit transaction under 'CF General' that includes the description "Cash" on todays date to automatically write that transaction under 'Daily.' However, Im running into trouble creating this.

Ideally, in 'CF General', inside a cell, I would write the date (Aug 2) under the date column (A), a description ("Cash") under the description column (B), and a credit amount to cash under the credit column (D). This could happen more than once for the same date. Excel would then isolate and total the cash entry for that date (or create two separate entries for the same date) and forward that information to the 'Daily' spreedsheet, Writing the correct date for that entry under column (A), and return the total amount spent under column (C).

I understand thats a bit complicated, so im happy with a 'Daily' spreedsheet cell under column (C) to add all credit cash entries if the two conditions are met. I can type the rest manually.

Thank you for any time you may have,
Oven