SUMIF Visible Cells (2007)

Topic

New Reply

I would like to know if anyone can help create the solution to use SUMIF based on multiple filtered columns. Attached is a sample that totals Allocated and Actual hours for several people, on several projects, working for several managers. Need to run Manager, Project and Resource reports. More definite details written into text boxes in the spreadsheet.

Reply | Quote

Replies

I couldn’t convert your workbook. However,

If you wanted SUMIF(A1:A10, “x”, B1:B10) to be restricted to the visible rows only, you could create a helper column C, where C1 = SUBTOTAL(109,B1) and drag down.

Then =SUMIF(A1:A10, “x”, C1:C10) would give you the sum of the row B values that 1) have “x” in column A of the same row and are visible.

Reply | Quote

Thanks Mike. Your solution worked the best for the reports we need. Servando, thanks! Hans, what can I say, you are always there with a solution! You guys are great…

Reply | Quote

How about a pivot table? See the attached version.

Reply | Quote

What about this?

Reply | Quote