Countif or Sumif?
Closed
Ms. Nikki
-
Dec 1, 2008 at 01:39 PM
sheryljohnson Posts 5 Registration date Saturday November 1, 2008 Status Member Last seen December 15, 2008 - Dec 3, 2008 at 02:14 AM
sheryljohnson Posts 5 Registration date Saturday November 1, 2008 Status Member Last seen December 15, 2008 - Dec 3, 2008 at 02:14 AM
Related:
- Countif or Sumif?
- How to count names in Excel: formula, using COUNTIF - Guide
1 response
sheryljohnson
Posts
5
Registration date
Saturday November 1, 2008
Status
Member
Last seen
December 15, 2008
4
Dec 3, 2008 at 02:14 AM
Dec 3, 2008 at 02:14 AM
Well, don't use not sumif nor countif.
Just use a simple if.
Your function should look something like that:
=if(sum(A1:A10)>E5,sum(A1:A10),"")
A simple translation of the above function would be:
If the sum of range A1:A10 is greater than cell E5, then write this sum, else leave it blank.
You can find here similar examples of using such if function:
http://www.microsoft-office-excel.com/if-statement.html
Note:
The Counif function is used to COUNT cells, it has nothing to do with totals or summing values.
The Sumif does sum up cells, but only WITHIN a range, cells that meet some criteria within a range.
Just use a simple if.
Your function should look something like that:
=if(sum(A1:A10)>E5,sum(A1:A10),"")
A simple translation of the above function would be:
If the sum of range A1:A10 is greater than cell E5, then write this sum, else leave it blank.
You can find here similar examples of using such if function:
http://www.microsoft-office-excel.com/if-statement.html
Note:
The Counif function is used to COUNT cells, it has nothing to do with totals or summing values.
The Sumif does sum up cells, but only WITHIN a range, cells that meet some criteria within a range.
