Hey guys,
Another little dilema...
In column A I have numbers such as: 13252, 13232, 13712 etc...
In column B I have numbers such as: 12, 45, 145, etc...
Is there a way of adding every row that has a specific number in row A and a specific number in row B?
For example... I want to add all the totals in column C where the 13252's in column A have a number 12 tied to it in column B...
13252 12 100$
13252 12 250$
13252 23 75$
13232 120 150$
13712 120 275$
In this case my formula would first find column A (13252 for this example) then go on to column B (12 for this example) and add 100$ + 250$ = 350$
Also in this case the (13232 | 120) and (13712 | 120) would not be added together because they dont have the same number in column A...
Any help?
Thanks again,
Pat.
Bookmarks