Hey everyone I need a little help please. I am trying to count the following:
If any cell in column H has an "f" then cell Q2 should display the total number of cells with "f" UNLESS the matching cell in column L contains a "P" then it should subtract that one from the total number in Q2.
Thanks for any help in advance!!
Have a look at the Help for the COUNTIFS function.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Did that... Can't find a countif/unless statement.
If any cell in column H has an "f" then cell Q2 should display the total number of cells with "f" UNLESS the matching cell in column L contains a "P" then it should subtract that one from the total number in Q2.
Formula:
Please Login or Register to view this content.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks