Question description:
This user has given permission to use the problem statement for this
blog.
Hi , I have two columns in XLS and it has value .
I need to check if either of the two value is true along with third column which has value . I need to count such columns
Solved by Z. D. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
09/08/2018 - 05:32
Hi
Excelchat Expert
09/08/2018 - 05:32
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern.
User
09/08/2018 - 05:33
I have one xls which has three columns . I need to check the value in first two columns if any of the two is true along with the third I need to count that row
Excelchat Expert
09/08/2018 - 05:33
I understand you need help in IF Formula in excel. May you please share the data you have so I can help you with your concern?
Excelchat Expert
09/08/2018 - 05:33
You can provide sample of that data in the document preview
User
09/08/2018 - 05:35
are u able to see
User
09/08/2018 - 05:35
i submitted
User
09/08/2018 - 05:35
data
Excelchat Expert
09/08/2018 - 05:35
Ok, can you please explain what is the criteria?
User
09/08/2018 - 05:36
now the criteria is I need to populate one column in another sheet of ssameworkbook
User
09/08/2018 - 05:36
in that new sheet for the first row A should be 1
User
09/08/2018 - 05:36
and if any of the B = PA and C=NO is true
User
09/08/2018 - 05:36
i need to count such rows
User
09/08/2018 - 05:36
there
Excelchat Expert
09/08/2018 - 05:37
Got it. I can help you with that. Before we proceed, just a friendly reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.
User
09/08/2018 - 05:37
ok
Excelchat Expert
09/08/2018 - 05:38
Alright, please give a moment to solve your problem. Thank you!
User
09/08/2018 - 05:38
sure
Excelchat Expert
09/08/2018 - 05:40
Can you check column D if this is the output you need?
User
09/08/2018 - 05:41
I have updated data
User
09/08/2018 - 05:41
but i need count
User
09/08/2018 - 05:41
thats what i said
User
09/08/2018 - 05:41
In another sheet of same workbook
Excelchat Expert
09/08/2018 - 05:41
IF A1=1, and either of this is true (B1=PA or C=NO) then count the data
User
09/08/2018 - 05:41
yes
Excelchat Expert
09/08/2018 - 05:41
Count the rows you mean?
User
09/08/2018 - 05:42
yeah, thats what
User
09/08/2018 - 05:42
count such rows and write in another sheer of same work book
User
09/08/2018 - 05:42
I need ans like
User
09/08/2018 - 05:42
1 4
User
09/08/2018 - 05:43
"1" is the first row and total count for that is 4
User
09/08/2018 - 05:43
similary
User
09/08/2018 - 05:43
2 2
User
09/08/2018 - 05:43
like this
Excelchat Expert
09/08/2018 - 05:44
Sorry, I don't get it why total count for first row is 4?
User
09/08/2018 - 05:44
no thats just example
Excelchat Expert
09/08/2018 - 05:45
Ok so my formula is correct, for this example count would total to 2 only correct? since only 2 met the criteria?
User
09/08/2018 - 05:45
yes , thats corect
User
09/08/2018 - 05:45
but how to write that in other sheet of same workbook
Excelchat Expert
09/08/2018 - 05:46
Ok we can SUM the total of Column D, please check Sheet2 A1 cell
User
09/08/2018 - 05:46
can i write how i need output
User
09/08/2018 - 05:46
in sheet 2
User
09/08/2018 - 05:46
?
Excelchat Expert
09/08/2018 - 05:47
This is the formula in sheet2: =SUM(Sheet1!D1:D8)
User
09/08/2018 - 05:47
no
Excelchat Expert
09/08/2018 - 05:47
This is the formula for Sheet 1-D1: =IF(AND(A1=1,OR(B1="PA",C1="No")),1,"")
User
09/08/2018 - 05:47
u are not understanding my req
Excelchat Expert
09/08/2018 - 05:47
Sorry about that. Can you please explain further?
User
09/08/2018 - 05:48
see I have two sheets
User
09/08/2018 - 05:48
One is blank and one has data
User
09/08/2018 - 05:48
Data sheet has priorities as first columns
User
09/08/2018 - 05:49
which can range from 1-7
User
09/08/2018 - 05:49
and then few more columns
User
09/08/2018 - 05:49
now in sheet two I need to put these 1-7 priorities
User
09/08/2018 - 05:49
as first column
User
09/08/2018 - 05:49
and total count that match my criteria
User
09/08/2018 - 05:50
For first row in ur formula A=1
User
09/08/2018 - 05:50
for secong A=2
User
09/08/2018 - 05:50
and it will go till 7
Excelchat Expert
09/08/2018 - 05:51
Sorry, do you have the excel file for me to understand how your data looks like?
Excelchat Expert
09/08/2018 - 05:51
Or you can show an example in Sheet2 on how the output should look like?
User
09/08/2018 - 05:51
okay
User
09/08/2018 - 05:52
give me a min
Excelchat Expert
09/08/2018 - 05:52
Thank you.
Excelchat Expert
09/08/2018 - 05:53
Ok so you mean count the total # of data that met the criteria per priorities?
User
09/08/2018 - 05:53
i have pasted my output
User
09/08/2018 - 05:53
so now basically i need column XX
User
09/08/2018 - 05:54
which will have the criteria I have given
User
09/08/2018 - 05:54
and data is in another sheet
User
09/08/2018 - 05:54
in same workbook
Excelchat Expert
09/08/2018 - 05:54
Ok please give me a moment
User
09/08/2018 - 05:58
??
Excelchat Expert
09/08/2018 - 05:58
Still working on the formula, thanks for the patience
User
09/08/2018 - 05:58
ok
Excelchat Expert
09/08/2018 - 05:59
Ok here's the formula for Sheet2, E2: =SUMIF(Sheet1!D1:D8,Sheet2!A2)
Excelchat Expert
09/08/2018 - 05:59
Do you have any questions/clarifications regarding the solution provided?
User
09/08/2018 - 06:00
ok
Excelchat Expert
09/08/2018 - 06:00
Are you satisfied with the solution provided?
Excelchat Expert
09/08/2018 - 06:01
So for this case, it will SUM the rows meeting the criteria per Priority
Excelchat Expert
09/08/2018 - 06:02
Here's the file for your reference
[Uploaded an Excel file]
Excelchat Expert
09/08/2018 - 06:02
Is there anything else that I can assist you with regarding this issue?
Excelchat Expert
09/08/2018 - 06:06
Hi, I have not received a reply from you for quite some time. I'm afraid the session will end automatically soon.. I sincerely hope we were able to address your concern.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.