I have a spreadsheet set out with 10 unique text entries in column A (row 2 through 11), and the same values in column C & E. In B, D, & F, I have a corresponding value that I am trying to sum. The easy solution is to put them all in one column, and use a basic sumif, but the spreadsheet needs to be laid out this way. How can I get it to work over multiple columns for both the range and sumrange? N2, N3, and so on is my criteria I'm matching it to. Here's where I'm at with the formula:

=sumif((A$2:A$11,C$2:C$11,E$2:E$11),N2,(B$2:B$11,D$2:D$11,F$2:F$11))

Anyone know what I'm doing wrong, or is this not possible with sumif?

=sumif((A$2:A$11,C$2:C$11,E$2:E$11),N2,(B$2:B$11,D$2:D$11,F$2:F$11))

Anyone know what I'm doing wrong, or is this not possible with sumif?

Last edited: