Adding to a current formula, if a certain word appears in a column of a different workshee

[CSpenard]

This is my current formula. I wish to add, If the word Georgetown appears in column Q4-Q45 from a different worksheet 'CDL Pipeline', how would I do so?


=COUNTIF('CDL Pipeline'!F4:F45,34820)

[benishiryo]

welcome to the forum. do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.

so you only want a count if 'CDL Pipeline' F4:F45 has 34820 and Q4-Q45 has the word "Georgetown"? try:
=COUNTIFS('CDL Pipeline'!F4:F45,34820,'CDL Pipeline'!Q4:Q45,"Georgetown")

[leelnich]

If you mean a worksheet of the same name in a DIFFERENT workbook, try this syntax:

Please Login or Register  to view this content.

The second workbook must be open to work w COUNTIFS. I believe you could use SUMPRODUCT instead on closed workbooks.

Please Login or Register  to view this content.