Consolidation based on both currency and date

[losincog]

Hi

I'd like to consolidate all entries from the Breakdown tab into each currency in the Consolidation tab, using a criteria based on col B6 and downwards + date in row E2 onwards in Breakdown tab. SUMIFS I have done is only the currency, so doesn't feel secure as if there was a look on BOTH date and currency

[oeldere]

With the code below to reange the data.

Please Login or Register  to view this content.

After that a pivot table.

See the attached file.