Okay I have another issue
I have working formula
=IF(COUNTIF('Tab2'!P40:P58,"Fully Meets Expectation"),"DOES MEET","DOES NOT MEET")
However I need it ignore blanks so I tired to below but it did not work....please help....need a correct formula
Not working formula:
=IF(AND('Tab2!P40:P58<>""),IF(COUNTIF(Tab2!P40:P58,"Fully Meets Expectation"),"DOES MET","DOES NOT MEET"))
If you have a more recent version of Excel, you could try using COUNTIFS. Alternatively, you can use SUMPRODUCT.
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
Upload a small sample file with desensitized data; show what you are working from and show the results you expect...typed in manually if necessary.
To upload a sample spreadsheet file:
Click 'Reply to Thread', click 'Go Advanced', scroll down and click 'Manage Attachments'. When you are done uploading click 'Done'.
I am using a Mac.
Do you mean that every non-blank cell in the range has to say "Fully Meets Expectation" for "DOES MEET" to be returned? What are the other possible text values in that range, are there many?
Audere est facere
Its a questionnaire and I have 3 columns for answering however only 2 columns of answer is required. If the questionnaire has only 2 columns answered I want it to ignore that column 3 was blank and the output is Does Meet.
Yes, your profile says that. Is it a recent version? Does it have COUNTIFS?I am using a Mac
Yes it does.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks