COUNTIF and "OR" criteria

[CR37]

Hi
i am attempting to check 2 criterias eg if title typed in checkout matches book list then it displays on loan /available otherwise I want another IF statemet to check if date returned is today/past then mark as available. But it tells me i have too many parameters...

=IF(COUNTIF('JAN Checkout'!D:D, 'Book Collection List'!B:B), "On Loan", "Available", IF(Books[[#Headers],[DATE RETURNED]]>=Today(),"Available", "On Loan"))

How do i resolve this?

Any help rendered will be greatly appreciated.

[CR37]

Also is there a way that a user can type in a text to search and all the cells containg parts of the string typed in will be highlighted?

[Glenn Kennedy]

Your thread title is awful! It should look like the phrase you'd use in a Google search. Since you're new here, I have changed it for you.

Now.

Read the yellow banner at the top of the page and attach a SMALL sample sheet.

[CR37]

Thank you for your assistance! appreciate it

[CR37]

i cant seem to attach the document. I am clicking o the 'attachements tab' but it doesnt open a dialog to allow me to attach
Could you please advise?

[CR37]

Ok managed to attach. kindly take a look thank u for your time and patience

[popipipo]

Please Login or Register  to view this content.

Try this formula

[CR37]

i tried the code but it gives an error- saying there is a problem with the formula...

[Glenn Kennedy]

Popipio is Dutch. They use ; as a separator and he forgot to change one of them to a comma.

=IF(COUNTIFS('JAN Checkout'!$D$3:$D$35,B3,'JAN Checkout'!$E$3:$E$35,">0")-COUNTIFS('JAN Checkout'!$D$3:$D$35,B3,'JAN Checkout'!$F$3:$F$35,">0")=0,"Available","On loan")

seems OK to me.

[CR37]

Awesome!! thank u so much for pointing that out!

[Glenn Kennedy]

A tiny error. Easily missed.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.