Hi guys.....
So i have a sheet with some values on and there are 2 colours, red and yellow. I'm after a formula that will total up values that are in a Red only, i assume this can be done just don't know how????????
Please see the attached example for a clearer picture.....
Thanks in advance to anyone that can help!!!
Maybe you can write this in I1: =SUBTOTAL(109, F2:F1000)
And filter your table by color (or anything else: by customer, by date, by amount etc)
Never use Merged Cells in Excel
See my example here
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
See this Function from an earlier post
It would be very helpful to know what makes them red or yellow. I assume it is a decision and therefore could be coded as such.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks