Hi,
I want to calculate the sum of a column but I have 4 lots of figures going down the column and I only want it to calculate the some of 2 of those 4.
The 4 figures: £4.80, £3.80, 31 & 25.
These 4 figures are within the column multiple times and I just want to have one cell that sums up the £3.80's and £4.80's within the column and then another cell to do a separate sum of the 25's and 31's.
Is this possible, if so how? Does it require an IF SUM formula of some sort?
Thanks,
Sally
Can you post a sample dataset that mimicks what you are dealing with?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Try using SUMIF like this
=SUM(SUMIF(A:A,{31,25}))
&
=SUM(SUMIF(A:A,{3.8,4.8}))
assumes data in column A
Audere est facere
Try something like this...
=SUM(SUMIF(A2:A15,{31,25}))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks sooo much for your help guys!
With your help I've managed to get it to work. I decided to split the £3.80 & £4.80 in the end so my 3 formulas now look like this:
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Couldn't have done it without your help!!!
THANK YOU!!!!!!
For a single criteria you don't need the SUM function:
=SUMIF('£ - 2014'!K10:K780,4.8)
=SUMIF('£ - 2014'!K10:K780,3.8)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks