Hi,

I'm trying to use sumifs with criteria that I'm struggling with. I have a table with item names in the first column, then 12 columns of numeric values - but importantly a few of the items do not have values in each of the 12 columns. I want to sum the columns if (1) the item names match the name in my summary table (that bit I can do, no problem) and (2) the rows contain values in all 12 columns - if there is even one missing value in the row for an item, I do not want to include that sum.

So either I somehow look for only the rows that have a count of 12 values or for rows that have 0 blank cells.

My first try was to create a new column counting the cells containing values and say True/False (using this: =IF(COUNT(C1,D1,E1,F1)=4, "TRUE", "FALSE") - that's a shortened version, but essentially I had that working fine). My thinking was that I could then use a second criteria in my sumifs formula to include only those = "True". But that doesn't work because the new sumif formula doesn't recognise the result of the true/false formula.

However, I'm now stuck as to how to either work around that (and I don't want to hard paste the results of that counting formula as it will change over time as the values in the table are updated) or include it in the main sumif formula. Any ideas on how I can do this?

I hope this is clear. Any help would be much appreciated. Thanks.