SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple rows &

**77highland** · 06-12-2024, 10:17 PM

Hi All,

I need a formula (presumably SUMPRODUCT) to sum a range that consists on multiple rows and columns, with multiple criteria accross several rows and columns.

I have attached an example workbook, colour coding the criteria to the criteria range.

Any help would be greatly appreciated

**windknife** · 06-12-2024, 10:44 PM

One way,

Please Login or Register  to view this content.

**77highland** · 06-13-2024, 07:26 AM

Worked perfectly, thank you very much.

**windknife** · 06-13-2024, 07:46 AM

You are welcome.

SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple rows &

LinkBack

Thread Tools

Rate This Thread

Display

SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple rows &

Re: SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple row

Re: SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple row

Re: SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sumproduct Count multiple criteria with range over multiple rows and columns

[SOLVED] Sumproduct across multiple rows/columns/criteria

[SOLVED] Lookup multiple criteria in multiple columns in multiple rows; return true if exists

[SOLVED] Sumproduct Across Columns and Rows with multiple criteria

SUMPRODUCT for multiple Criteria across Columns and Rows as well as Sheets

[SOLVED] Sumproduct for multiple criteria across columns and rows

Sum multiple rows based on criteria spread across multiple rows and columns

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions