Assuming your data in in A1:A10 and a header row in row 1

In C1: =SUBTOTAL(9,A2:A10)

Home Tab Auto Filter Filter select Filter by color


"benmormedical" wrote:

I have created a worksheet with a list of quotes that are either outstanding
or have produced a sale and I am using the good, bad and neutral styles to
distinguish which is which, eg. a quote that has resulted in a sale is
highlighted as 'good' (light green shading with a dark green font).
I want a cell at the top of the sheet that adds all of the outstanding
quotes together to show how much possible revenue is outstanding, I have
tried using the SUMIF function but I dont know how to describe the cells when
writing the formula so that it only adds the outstanding ones.

help? :S