Excel Conditional Sum formula with filters in excel

R

RTB977

Joined
Jul 19, 2011
Messages
1
Reaction score
0
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.
 
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
 
Back
Top