Sum If + Count

Closed
Chris - Aug 5, 2011 at 10:53 AM
Ambucias
Posts
47363
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
- Aug 5, 2011 at 04:05 PM
Hello,

I have this formula

=SUMIF(VAS!$D:$D,$F6,VAS!$J:$J)

And wanted to add another step... the step would be to only sum VAS!$J:$J if ">2"

How do I add that to the overall formula?

=SUMIF(VAS!$D:$D,$F6,VAS!$J:$J)=COUNTIF(VAS!$J:$J,">2")?

1 reply

Ambucias
Posts
47363
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,278
Aug 5, 2011 at 04:05 PM
Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0