Hi,
I had this sumif formula:
=SUMIF(Data!C7:$C$435,"<>",Data!$CV$7:$CV$435)
but I now need it to exclude "". On a vlookup I have IFERROR return "" and thererore this is still being picked up. How can I exclude it?
Hi,
I had this sumif formula:
=SUMIF(Data!C7:$C$435,"<>",Data!$CV$7:$CV$435)
but I now need it to exclude "". On a vlookup I have IFERROR return "" and thererore this is still being picked up. How can I exclude it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks