I have a few formulas that use sumproduct and isnumber, which look like this:
They are all fairly similar. They basically look down column A and check that it's a number (date), then check the month of the date to check that it matches the given number (in this case 4, April), it then checks column C for the text "FL", etc. The end result is a single figure. I have about 15 of these on various pages in a workbook that look at different ranges.Please Login or Register to view this content.
They work brilliantly and do exactly what I need, except that occasionally rogue spaces creep into columns A or B (the other columns are either formula results or data validation lists) which totally throw off Isnumber leaving me with #Value results.
Is there anyway to adjust the formula above to ignore the spaces?
Bookmarks