wrong data type

Hi all, I am trying to compare a range against a single value to see if it exists and return a single Boolean T/F result. The formula is: =IF(COUNTIF(RANGE,CRITERIA)>0, "TRUE", "FALSE") The problem I'm having is the way I supply the RANGE to COUNTIF will be fine if I explicitly highlight...

I am using a formula in a couple of cells that excel doesn't pick up as a number. In cell c15, I am adding up cells c12 through c14. In that cell, I get the error message "A value used in the formula is the wrong data type." In c12 and c13, I am using a formula, which I assume, excel doesn't...

I am creating a macro in Excel 2010 that selects a range of data (which changes each month) and copies that range into a table in Access 2010. I am getting the error message "Run-time Error 2498: An expression you entered is the wrong data type for one of the arguments." The macro stops at...

Could somebody help please this is driving me mad! I am trying to use FIND and an array formula to find the position of text in a range of cells (A2 and A3 in the example) which could be one of a number of options (C1:D1 here). But the array formula throws up the following error: "A value used...

I have an excel macro that copies a tab from the previous month, renames it to the correct month, and replaces the formulas with the correct month/formula. The issue I ran into is that when it replaces the formula with the correct month, it returns #Value and says "wrong data type". I believe...