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

is there such a thing as "sumif) with 2 arguments? thanks. (we're so excel help, aren't we?) -- nm

Posted by amanda jones (aka amanda) Dec 9 '10, 07:12

(No message)

Responses:

there is indeed. you want SUMIFS -- nm - loosilu Dec 9, 07:15 7
- 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.