Sumif with Multiple Criteria
Posted by Debbie on August 01, 2000 4:44 AM
Will Sumif work with 2 criteria? I have 2 worksheets, the 1st worksheet is a database by tax type for each location and the 2nd worksheet is a journal entry. Basically what I want the formula (on worksheet 2) to do is if:
Worksheet1 A:A = Worksheet2 B1 AND Worksheet1 B:B = Worksheet2 C1, then sum the numbers.
FYI-Column 1 is tax type, (FICA, STATE, etc.) and Column 2 is location. I like to avoid a VB programming situation but I might have to resort to it yet to create this massive journal entry.