May 28 2021 06:59 AM
Hi,
I have a column of data in excel which is based on a VLOOKUP bringing back various data items (dates mainly but some #n/a as expected) from another data source.
What i am trying to do is count the number of times a date is is then brought back to that column...at the moment it always brings back 0 as the cells have the formula which i need to keep dynamic
Is it possible to COUNTIF the VLOOKUP data that is returned?
TIA
May 28 2021 07:14 AM
So you basically want to count the cells that do not show #N/A ?
If so, use a formula such as
=SUMPRODUCT(--ISNUMBER(D2:D100))
where D2:D100 is the range with the formulas.
May 28 2021 07:20 AM
Thanks.
I need to count the data based on a COUNTIF.
So if the column with the VLOOKUP has various dates, I am looking to count those individual dates...
e.g.
Column D (which is where the VLOOKUP is) may bring back 04/04/21, 05/04/21, NA, 12/03/21, 05/04/21 etc
I am looking to carry out a COUNTIF using these dates to see how many times each date is then
So i am using =COUNTIF(D:D,A1) (where A1 would have a date - say 05/04/21 for example) - so should being back the count of 2 on the above list
Does that make sense?
TIA
May 28 2021 07:30 AM
The formula looks OK, whether column D contains formulas or not. Do you have a problem with it, and if so, which problem?
May 28 2021 07:38 AM
May 28 2021 07:53 AM - edited May 28 2021 07:54 AM
SolutionDoes column E on Sheet 1 contain 'real' dates, or text values that look like dates?
Or are they dates that have a time component?
Same question for column A on Sheet 2.
Jun 03 2021 12:50 AM
May 28 2021 07:53 AM - edited May 28 2021 07:54 AM
SolutionDoes column E on Sheet 1 contain 'real' dates, or text values that look like dates?
Or are they dates that have a time component?
Same question for column A on Sheet 2.