Most valuable professional
  • Hot Topics

Excel Calculate the first four cells based on condition

A x x x x x x x x x y In the above example, i want to sum the first four cells where data in column a and column b is matching and after summing the first four values, i want excel to sum the rest of the values for the matching data in column in a and b which not necessary would be 4, but will be less. I have the written the array formula for this using count if and sumifs but that is giving me the sum of total values. {=IF(COUNTIFS($A$2:$A3,A3,$B$2:$B3,B3)>1,"",SUMIFS(C:C,A:A,A3,B:B,B3))} Is it possible? Please help, i'm stuck

This question generated 43 answers. To proceed to the answers, click here.

This thread is current as of July 12, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel