Count

[zinah]

Hi,

I want to use sumif or any suitable formula that has 3 different conditions: count how many %s that this specific question has from the range in column P (after rounding these %s to match column P), I used this formula =SUMIFS('Immediate Manager'!K:K,">="&P2,'Immediate Manager'!K:K,"<"&P2+0.01,'Immediate Manager'!D:D,Sheet1!$A$1) but I got msg box "You have entered too few few arguments for this function", I'm not sure what I missed exactly. Below is the explanation of my formula:
- 'Immediate Manager'!K:K = is the %
- P2 = is the range
- Sheet1!$A$1 = the question list

Can anyone help please?

And below is the screenshot of my data:

 

[Joe4]

SUMIFS always has an odd number of arguments; first the range you wish to sum, the the corresponding pairs of ranges and criteria.
You have an even number of arguments.

See here for a complete explanation on how to use SUMIFS and an exanple: How to use the Excel SUMIFS function | Exceljet).

 

[Eric W]

It also sounds like you might want COUNTIFS instead of SUMIFS.