Mike_Alex
New member
I was a little thrown back by this one, thought it was just an automatic. I built a simple spreadsheet with a table in it and used a bunch of sumif and sumifs to pull the table data together (used the table column names in the calc). I inserted a slicer to filter one of the columns, but found that if you have a table and perform a sumif or sumifs on it, it will return the column total without the slicer selection. Is it possible that I missed a setting or can you really not sum up a table column with a slicer value as a criteria? I find it hard to believe, hence why I ask.