if function help

  • Thread starter Thread starter gina_b
  • Start date Start date
G

gina_b

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
 
Thanks MarkN!!

This worked and is much more streamlined than the long formula I ha
earlier. Thank you so much!

Gin
 
Back
Top