sum function

A

angie

i want to sum only filtered records in my worksheet. is that possible?

with the sum function this does not work. could i use another function?
 
T

T. Valko

Use the SUBTOTAL function.

Look up SUBTOTAL in Excel Help to see all the variations that are possible.
 
M

Marcelo

check the help for the subtotal funcion

to sum filtered cells is =subotal(9,a2:a1000)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"angie" escreveu:
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
Multiple logic functions with multiple sums 2
Getting sum of values in another sheet while using condition 5
Using SUM(INDIRECT()) 2
Multiple IF Statement in Word 5
Sum Function has small remainder 2
Sum every Nth Row (almost working) 2
Excel - Wich Function should I use? 1

Top