Yakuzaibu

(2) Select the Sales Person column (the column you will count), and click Calculate > Count (3) Set combining rules for other columns based on your needs The columns just have one specific word only, but in multiple rows So for example = COUNTIFS('Raw Data'!A3Y225,D14,'Raw Data'!Y2, C15), where A3Y225,D14 are the rows to check and 'Raw Data'!Y2, C15 the header Now I know, that countif needs the same amount of rows And I tried to solve it with On yellow fill cells are the result that i need (i count it manually) Basically, i need to count how many time the number appears (doesnt matter the sums of them) eg on "ITEM 1" the number appears 5 on "NEW" criteria, and 1 on "USED" criteria Thanks you Best Regards Excel Sumproduct Multiple Criteria Myexcelonline Excel countif multiple criteria different column and row