So I need to have Excel check one column for a particular value and then
check a different column in the same row if the it found the particular
value in the original column.

In the end I need it to tally up the total amount of finding x in this
col/row and finding y in the next col/same row.

I've been toying with this for hours.

Heres sort of what I am talking about

if(col/row = "whatever" and col/same row = "this", return/sum/count)

Please help me!!!!

THX

-Anthony

ps noob to the forum, but not noob to excel.


--
iamtwon
------------------------------------------------------------------------
iamtwon's Profile: http://www.excelforum.com/member.php...o&userid=34630
View this thread: http://www.excelforum.com/showthread...hreadid=544027