Excel Conditional Sum formula with filters in excel

[RTB977]

Hi all,

I have data in columns Z through AC that I want to sum only if column X is greater than zero. I know a SUMIF formula would work for this, however I filter this data constantly and a SUMIF formula doesn't update with the filters, but keeps the all up total. A SUBTOTAL updates with the filters, but I can't make it sum only X is greater than zero. Does anyone know a workaround for this?

Thanks in advance.

 

[Stoneboysteve]

RTB977.
Try something like this (not actual formula, you will need to add the correct cell location):

=if(x>0,(sumz:ac),"X not greater then zero")

Stoneboysteve