Forum members,
Another silly question. I want to put some text before my formula so I can get everything in 1 cell. This is what I'm looking for but can't get it to work: = "DAYS IN UK TOTAL " [and them my formula] (COUNTIF(B2:B366,"UK") which will give me a number answer. Trying to impress the tax man, any help appreciated.
To simplify want to do this: Days in UK: Number (derived from formula above).
welcome to the forum. maybe:
="DAYS IN UK: "&COUNTIF(B2:B366,"UK")
or format cells to Custom:
"DAYS IN UK: "#
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Will try in the morning. Many many days months and years in Singapore, my favourite place.
Formula:
= "DAYS IN UK TOTAL " & COUNTIF(B2:B366,"UK")
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks