• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

AND function as a criteria in SUMIFS function

A

Asmin

New Member
Hi,
I tried a few different ways but this sumifs formula is not calculating correctly. I am not sure what is wrong with the formula. Please help.

When the same row in CQ equals "Short-term" and the row in AU is greater than column A11 (a number), add up the rows in column AD.
=SUMIFS(AD75:AD122,CQ75:CQ122,"Short-term", AU75:AU122,">"&A11)
 
Asmin

Firstly, Welcome to the Chandoo.org Forums

You will note that I shifted your post to its own thread, Do not ask questions on someone elses thread as you risk it not being seen at all

There's nothing wrong with the formula

I'd suggest that Column CQ may have a space or other character at the end or start like:
"Short-term "
or
" Short-term"

Can you post a sample file here so we can review?
 
You must log in or register to reply here.
Back
Top