Paste damages formula in autofilter

  • Thread starter Thread starter shawb
  • Start date Start date
S

shawb

Formula is merely an if
if(B2 > 0,1,0)
could also probably use countif

nb: I can't use a summation here as some of my macro's use differen
filters in combination with subtotal and sums alread
 
Hi
if this formula is ion column C (cell C2) try:
=IF(OFFSET(C2,0,-1)>0,1,0)

or
--(OFFSET(C2,0,-1)>0)

But I'm quite sure you could use a SUMPRODUCT formula
insetad. Even with filtered rows. Just provide some more
details about your layout and what you're trying to achieve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste damages formula in autofilter 1
Conditional Autofilter For Formula 4
conditional formatting formula to highlight items on column B inrelation to column A 3
Paste damages formula in autofilter 1
Excel Macro to use cells as a autofilter 0
Excel 2013: AutoFilter and SUM() 1
Subtotal counting formula in cells 1
Sum a Filtered List excluding Negative Numbers 6

Back
Top