Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

List - Create a view that shows totals

  Asked By: Willis    Date: Feb 09    Category: Sharepoint    Views: 2932

You can definately tell I am a newbie at sharepoint. I know what I
want to do but I don't have the experience to get it done. I have a
list that has a bunch of columms. One of them is called "Sold". It
has a check box option of yes or no. Then I have one called "Price".
I have a view that filters by "Sold" being yes and then sums "price"
to show how much we have sold.

That is exaclty what I want as far as returned data but I would like
to make it just show a total and not the columns. I am going to add
the view to the front page so we can keep a running total of what has
been sold. It is for a fund raiser for United Way.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Matt Prince     Answered On: Feb 09

OK I am still struggling on this and I am sure I am making it a lot
harder then it should be.

If I copy my data  into excel and add a new colum and have a cell that
has this formula I get exactly what I want.

=SUMIF(B1:B10,"=TRUE",C2:C10)

The columns  in sharepoint  that it is referring to is:

=SUMIF(SOLD,"=TRUE",PRICE)

I don't know how to do something like this in sharepoint. Basically I
want a list  view or something that i can put on the home page  that
calculates a forumla like above that just shows  a running total  of the
funds raised by all sold items.

 
Didn't find what you were looking for? Find more on List - Create a view that shows totals Or get search suggestion and latest updates.




Tagged: