• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add across multiple columns with criteria in columns and rows

Vivian Seidner

New Member
I want to sum data across multiple columns based on the column header and a row attribute.

Months in columns across: Data!$D$5:$W$5 = Report!C$5 (columns incremented across)
Accounts in rows down: Data!$A$6:$A$149 = Report!$A6 (rows are incremented downwards)
Data range: Data!$D$6:$W$149

Need to add up all data for certain accounts if the months are in a certain date range.

SUMIFS(Data!$D$6:$W$149,Data!$A$6:$A$149,Report!$A6,Data!$D$6:$d$149,Report!C$5) returns #VALUE!

Is SUMPRODUCT the solution? If so, please help me with the formula.
 
For something like this it is way easier for someone to provide a solution if you provide a your file or a sample file.
 
Back
Top