Hi there,

I've got a small table of financial data that I want to summarize on a
second worksheet in the same workbook.  A sample of the table is right
below.

I'd like to say if Column C = 1 and Column D = Editorial, then retrieve
the total number of the Invoice Amount for those rows in Column C.  All
of these columns are on sheetone of my workbook, and I'm creating the
formula on sheettwo within the same workbook.

I've got this formual below, but it's not giving me any results.  In
this case, the total should be 90,000, but I get nothing.  Is there
something wrong in the formula?  Is there something happening because
I'm putting this formula on a different worksheet?

=IF(AND('sheetone'!c:c="1",'sheetone'!d:d="Editorial"),'sheetone'!b:b,"")

Thanks!!!!

Gina

a        /                 b               /          c              
/       d

Vendor     /         InvoiceAmount    /Qtr(s) of Inv    /Budget Group
VendorOne/    90,000.00    /1             /   Editorial
VendorTwo    /27,000.00    /4             /   Consultants
VendorThree    /87,000.00    /2              /  Editorial