![]() =SUM(IF(B1:J1="Feb",IF(A2:A7="Tom",B2:J7)))Īnd then press Shift + Ctrl + Enter keys together to get the result, see screenshot: Here, you can apply the following formulas to sum the cells based on both the column and row criteria, please do as this:Įnter any one of the below formulas into a blank cell where you want to output the result: Sum cells based on column and row criteria with formulas ![]() ![]() This article, I will talk about some useful formulas to solve it. For example, to sum the cells which column criteria is Tom and the row criteria is Feb as following screenshot shown. I have a range of data which contains row and column headers, now, I want to take a sum of the cells that meet both column and row header criteria. How to sum based on column and row criteria in Excel?
0 Comments
Leave a Reply. |