ST Alpha - "is that a new function in Office 2007? i don't believe it exists in older versions of Excel. -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 161

In response to "there is indeed. you want SUMIFS -- nm" by loosilu

is that a new function in Office 2007? i don't believe it exists in older versions of Excel. -- nm

Posted by TFox Dec 9 '10, 07:18

(No message)

Responses:

just googled... yes it is. -- nm - loosilu Dec 9, 07:20 5
- well then, that is awesome and i would love to have it in my excel. -- nm - TFox Dec 9, 07:21 4
  - honestly, I prefer to use SUMPRODUCT instead. I tend to have even more than two criteria. -- nm - loosilu Dec 9, 07:22 3
    - sumifs can nest up to seven. -- nm - amanda jones Dec 9, 07:24 2
      - ah, good to know. I prefer SUMPRODUCT because it's cleaner. -- nm - loosilu Dec 9, 07:25 1
        
        (I tend to lose track of nested parentheses) -- nm - loosilu Dec 9, 07:25

Post a message top

Replies are disabled on threads older than 7 days.