1. 5

    Multiple If(Match not working as I'd expect

    An Excel spreadsheet currently exists which has several years worth of data. In the past, exclusion codes were eight characters in length and they were always at the end of the comment. The previous formula worked fine before the exclusion codes were changed and the method of entering the...
  2. A

    SUMIFS( with OR(

    I'm trying to use a SUMIFS( function with multiple criteria in one of the arugments. I want to use OR( for one of the criteria, but it never seems to work no matter what syntax I use. I've had multiple occasions where I wanted to use OR( with SUMIFS, COUNTIFS, and AVERAGIFS and I'm always told...

Some videos you may like

This Week's Hot Topics