ST Alpha - "honestly, I prefer to use SUMPRODUCT instead. I tend to have even more than two criteria. -- 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 "well then, that is awesome and i would love to have it in my excel. -- nm" by TFox

honestly, I prefer to use SUMPRODUCT instead. I tend to have even more than two criteria. -- nm

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

(No message)

Responses:

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.