User Profile
Jamesb1982
Copper Contributor
Joined May 18, 2023
User Widgets
Recent Discussions
- 1.1KViews0likes0Comments
Formula for Countif
Good Morning Guys I'm trying to do a countif formula. I want to count the amount of entrys in B based on the ranges between E&F to be added to total in H. Can any help. I've not really done ranges before. Or if anyone can suggest an alternative. I have enclosed a test excel.Solved1.2KViews0likes2CommentsExcel formula Help
Hey Guys. I'm using a formula of =E445 + IF((G445 = "Yes "), 28, 14) to calcuate a date. However, when either E445 or G445 are blank its giving a value of 14/01/1900. Any idea how if the entry is blank the response will be blank until data is entered? Thanks497Views0likes2Comments
Recent Blog Articles
No content to show