I WANT TO USE THE SUMIF FUNCTION WITH DATA SERIES MORE THAN ONE C.

[Guest]

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,

 

[Ken Wright]

Take a look at the SUMPRODUCT function

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