Multiple COUNTIF(S)

[mingandmong]

Hi im using excel 2016
i am having problems with my formula

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]'=COUNTIFS(full_extract!E:E,full_extract!G:G"1",A1)

count value from sheet column E:E, when column G=1 against the data in A1.. i get a syntax error

thankyou
[/FONT]

 

[sandy666]

see: COUNTIFS()

 

[mingandmong]

Hi sandy666 still not working with () after COUNTIFS()

 

[sandy666]

did you read about syntax of COUNTIFS function?
your syntax from post#1 is wrong

Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other.

and read Remarks there.

 

[mingandmong]

hi sandy666
i was not aware your answer was a hyperkink
but i cannot get this to wrk
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]'=COUNTIF(full_extract!D:D,full_extract!G:G"1",full_extract!W3)
count d:d where're g=1 and w 3 = (preset data )

[/FONT]

 

[sandy666]

SYNTAX: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

=COUNTIFS(full_extract!D:D,full_extract!G:G"1",full_extract!W3) (error: no comma)

range1: full_extract!D:D
criteria1: ?
range2: full_extract!G:G but not full_extract!G:G"1"
criteria2: "1"
what is it?: full_extract!W3

don't forget about commas

eg. =COUNTIFS(B5:D5,"=Yes",B3:D3,"=Yes")

read carefully whole description about COUNTIFS (and examples there)

 

[Eric W]

Something like this?

=COUNTIFS(full_extract!D:D,full_extract!G:G,"1",full_extract!W:W,3)

Also note that you have the 1 in quotes "1", indicating that it is a text field, and the 3 without them, indicating a numeric field. Make sure you have those correct to match your data.


Edit: upon rereading your question, I'm unsure as to what you actually are asking. Are you looking to search column W for a 3, or are you looking to see if W3 contains a specific value?

 

[mingandmong]

hi sandy w3 = 74698
sO
COUNTIF THE VALUE of D:D, if the value of G:G = 1 = VALUE OF W3(74698)

 

[mingandmong]

=COUNTIFS(full_extract!D:D,full_extract!G:G"1",A3
GIVES AN ISSUE above G:G "a1

 

[sandy666]

would be better if you post a link to shared (use GoogleDrive, OneDrive or any similar) excel file with representative source data (desensitized) and expected result
detailed description what you want to do is very welcome