if function help
 

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="Editori al"),'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


--
gina_b
------------------------------------------------------------------------
gina_b's Profile: http://www.excelforum.com/member.php...o&userid=29996
View this thread: http://www.excelforum.com/showthread...hreadid=553438

if function help
 

Gina,

How about
=SUMPRODUCT(--(C2:C5=1),--(D2:D5 ="Editorial"),B2:B5)
--
Hope that helps,
MarkN


"gina_b" wrote:


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="Editori al"),'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


--
gina_b
------------------------------------------------------------------------
gina_b's Profile: http://www.excelforum.com/member.php...o&userid=29996
View this thread: http://www.excelforum.com/showthread...hreadid=553438

if function help
 

Thanks MarkN!!

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

Gina


--
gina_b
------------------------------------------------------------------------
gina_b's Profile: http://www.excelforum.com/member.php...o&userid=29996
View this thread: http://www.excelforum.com/showthread...hreadid=553438