Hi, I've a column of 18 numbers going from 0-5. I only want to add the numbers that exceed 2. So basically if the numbers were 1,3,5,2,0,2 the total would be 8 (3+5). The 0, 1 and 2's would be disregarded. I know it must be simple but I don't know the function. I've tried count if and putting in >2 but that didn't work.
Any help appreciated.
Last edited by Marvo; 09-16-2013 at 05:18 PM.
Try this:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Or =SUMIF(A2:A7, ">2")
Entia non sunt multiplicanda sine necessitate
That works a treat, thank you very very much.
Here is another way:
Enter with Ctrl+Shift+EnterFormula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks