CountIf Formula
I got a call from the Cost Reduction team how to set-up an auto-count for their tally. Here is the scenario:
In the tally field column you have to write the formula that is written in column L.
How does it works?
=COUNTIF(Source Range for the Count,Cell containing the Criteria)
In Cell L5 for example Type "A" tallies to 4. It's Source Range is H5:H10 and it's criteria is K5 which contains Type "A".
Microsoft Excel provides this function that can be used to analyze your data based on a condition. For example, to calculate a sum based on a string of text or a number within a range, use the SUMIF worksheet function. To have a formula return one of two values based on a condition, such as a sales bonus based on a specified sales amount, use the IF worksheet function.
posted by Noel J @ 10:30 AM
0 Comments:
Post a Comment
<< Home