# Arrays

/Arrays

## Last Used Cell In A Row

Last Cell used on a Row Find the reference of the last cell used in a row By Neale Blackwood One of the articles on our site allows you to find the cell reference of the last used cell in a column. You can see it below in the related articles. Someone asked if there [...]

## Multi-Criteria SUMIF

Multi-criteria SUMIF I use SUMIF to sum a range based on one condition. Is there a way to sum a range based on two or more conditions? By Neale Blackwood One way is to use SUMPRODUCT. The following formula will sum the range C1:C10 based on the contents of A1:A10 and B1:B10. Cell E1 [...]

## SUMIF – More Than One Condition

SUMIF - more than one condition Q: I know how to use SUMIF with one matching criteria, but how can I use more than one? By Jeff Robson Short Answer: you can't.  SUMIF only accepts one criteria.  Use the SUMIFS formula instead as it allows this (Excel 2007+) Long Answer: you can still use [...]

## Last Used Cell In A Row

Last Used Cell in a Row Find the reference of the last used cell in a row By Neale Blackwood One of the articles on our site allows you to find the cell reference of the last used cell in a column. You can see it below in the related articles. One of our [...]