I have a spreadsheet with about 6 columns and 25 rows of data. One of the
columns represents dollar amounts...and the remaining columns represent
account names, account numbers...etc.
I'm trying to come up with a way to sum all the dollar amounts if the data
in the other columns is the same.
I've used the sumif formula when I have only one piece of data I'm looking
for in common, but how can I get the same result when I'm looking for
information with at least two columns of the same data?
I've tried used the sumproduct formula.
=SUMPRODUCT(($B$106:$B$505="*042000314*")*($D$106: $D$505="*637185059*")*($L$106:$L$500))
However I keep getting a #N/A result.
Any idea why this isn't working?