I would like to use a formula to search criteria in multiple columns. If the data in both columns matches the criteria, different set of criteria for each column, then sum figures in a another column. Example, if Obj=Bal and Tax=Non then sum "totals":
Total OBJ Tax
-------------- --- ---
20974625.09 Bal Tax
12749493.45 Bal Tax
11922405.7 Fix Tax
10393031.33 Bal Non
7689070.12 Fix Tax
6798423.8 Bal Non
Thanks for your help
Total OBJ Tax
-------------- --- ---
20974625.09 Bal Tax
12749493.45 Bal Tax
11922405.7 Fix Tax
10393031.33 Bal Non
7689070.12 Fix Tax
6798423.8 Bal Non
Thanks for your help