compare 2 cells

[Blinx]

Hi all


so i need help with something

tried for about 3 days now and cannot figure it out, ive tried looking at google but to no avail

basically i have a huge spreadsheet with differnet headings

i need to compare 2 values of each row. Heading "priority" and heading "pass/fail"

so if the row contains the word "pass" then check the same row to see if it has "1" in the priority title , if both of the conditions match then it counts +1 for each value

so if i change 10 cells to pass and then the 10 rows have 1 in the priortiy column then my output should be 10
however

if i have 10 passes and only 5 have the number 1 in priorty then the output shouold be 5 ( as im only counting the number of passes with a priority of 1

i have

prioritys of a value, 1, 2 and 3
pass of fails

i hope it makes sense lol

in the sense of apples n pears
if i have a bunch of adult names, and a bunch of fruit.

how many adults named john have an apple.

to which adults names would be 1 variable,
fruit would be the 2nd variable
so in that example, look only people named john and have an apple

cheers lol

 

[mikerickson]

Have you tried COUNTIFS. You don't mention the addresses of the columns in question, but it might look like

=COUNTIFS(A:A, "pass", B:B, 1)

 

[Blinx]

thanks so much for replying so quick!

Would this count all rows with "pass" and if the condition is passed then the 2nd condition is met of having "1" in the row

I want to count all passes with priority 2 as a seperate formula and all rows with pass and priority 3

its just so when i have completed my work as passed then it will add up the total amount work i completed as "passed" but at priorty 1

 

[sunny102]

this formula will help you

=COUNTIFS(A:A, "pass", B:B, 1)

 

[mikerickson]

...
Would this count all rows with "pass" and if the condition is passed then the 2nd condition is met of having "1" in the row...

What happened when you tried it?

 

[Blinx]

OMG amazing!! sorry for late reply, i was updating my entire spreadsheet with this!!

this is suupeeeerb!!!