Why is SUMIF function not working when data is formatted as a table?
December 7, 2013 8:54 AM Subscribe
I am developing a sales lead sheet. I have on the B column a drop down list for the sales status (complete, no sale, and follow up). On the A column I have a dollar amount for the sales lead. Originally, I used the SUMIF function to add only the "follow up" figures referenced from Column B to track the dollar amount of outstanding leads. I then thought to convert my sheet into a table to make sorting easier, but now the SUMIF function is returning a value of zero. What did I miss? Thanks much!
posted by FireStyle to Computers & Internet (2 answers total) 1 user marked this as a favorite