I am attaching a spreadsheet containing a simple example of what I want to do and the results I want. sum with criteria.xls
In summary, I have 2 ranges.
If the value in one range's cell matches a value in the other range, I want to add an associated cell from the first range to the related one in the other range and put that result in a new range.
The formula I've tried is:My syntax is bad, among other things, I'm sure. Need help with this. Thanks.![]()
=IF(Range2=A11, Twenty10b+B11, B11)
Bookmarks