ST Alpha - "there is indeed. you want SUMIFS -- 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 "is there such a thing as "sumif) with 2 arguments? thanks. (we're so excel help, aren't we?) -- nm" by amanda jones

there is indeed. you want SUMIFS -- nm

Posted by loosilu (aka loosilu2) Dec 9 '10, 07:15

(No message)

Responses:

is that a new function in Office 2007? i don't believe it exists in older versions of Excel. -- nm - TFox Dec 9, 07:18 6
- 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.