CODEWITHSUNDEEP
excelexcel-formula
stephenp
stephenp

Reputation: 3

How to COUNT values according to mult criteria and using OR logic

I'm trying to count values according to multiple criteria based on two separate columns. This is the function I have written.

=COUNTIFS([Category2],"Account Management",[VA/NVA/NNVA/D],{"NVA","NNVA"})

Essentially, the function is supposed to look in Column D to see if it says "Account Management", THEN it looks two columns over at Column F to see if it says "NVA" OR "NNVA". If it says either, it gets a count.

However, my function is returning a value of 5 when it should be 39.

Here is a picture of the spreadsheet.

Upvotes: 0

Views: 46

Answers (1)

Lux Claridge
Lux Claridge

Reputation: 205

Adding sum should do the trick:

=SUM(COUNTIFS([Category 2],"Account Management",[VA/NVA/NNVA/D],{"NVA","NNVA"}))

I found this trick at Excel Jet and tried the formula without actually reading the explanation so I cannot relay the logic behind this.

Upvotes: 1

Related Questions