It's probably easier if I ask this using an example, so please reference this
sample:
A B
1 0.3 0.2
2 0.4 0.3
3 0.5 0.4
4 # N/A N/A 0.5
I use a Bloomberg add-in to automatically load data into Excel. If for some
reason this data is not available, the add-in will return a value such as the
one seen in cell A4.
What I'm trying to do is sum these numbers and calculate the percentage
change from the sum of column B to the sum of column A. However, calculating
the percentage change in three quarters' worth of data over four is useless,
so I'm trying to find a way (SUMIF?) to exclude cell B4 from the sum
calculation of column B if the adjacent cell (A4) is blank or contains an
error code like the one shown above. Is this possible?
Thanks so much for the help!
Bookmarks