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.
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.