As someone in a more traditional analyst role, I love these series you have put together. I always opt for SUMIFS and COUNTIFS over SUMIF and COUNTIF as it makes it easier to add conditions later.
SUMIFS
COUNTIFS
SUMIF
COUNTIF
Thanks!
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
As someone in a more traditional analyst role, I love these series you have put together. I always opt for
SUMIFSandCOUNTIFSoverSUMIFandCOUNTIFas it makes it easier to add conditions later.Thanks!