FOR EXAMPLE IF I HAVE 3 COLUMNS AND I WANT THE FUNCTION TO TAKE 2 DIFFERENT
CRITERIAS FROM COLUMNS 1 AND 2 AND I WANT TO HAVE THE SUM RESULTS FROM THE
3RD COLUMN THAT MATCH THOSE 2 CRITIRIAS FROM THE FIRST 2 COLUMNS,

Take a look at the SUMPRODUCT function

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"THANOS" wrote in message
...
FOR EXAMPLE IF I HAVE 3 COLUMNS AND I WANT THE FUNCTION TO TAKE 2 DIFFERENT
CRITERIAS FROM COLUMNS 1 AND 2 AND I WANT TO HAVE THE SUM RESULTS FROM THE
3RD COLUMN THAT MATCH THOSE 2 CRITIRIAS FROM THE FIRST 2 COLUMNS,