I was using excel today and I wanted to count all the cells in a range only when there is a value greater than 2. So I started hunting for a funciton in excel and found the countif function.
Countif(range,criteria)
But when I started using it like this -- Countif(A1:A100,>2) it didn't work. It was coming up with an error.
So I tried Countif(A1:A100,">2"). This worked. So if we include the criteria in quotes then the formula worked.
I also noticed a sumif function that also works in a similar way. It populates the sum of all the cells in the range specified that satisfy the criteria given.
Subscribe to:
Post Comments (Atom)
Free Power BI Classes for Week 7 (Last)
Just completed the last class of the F ree P ower BI classes of this series. Today we have covered Adding a canvas background Adding Imag...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
1 comment:
Well, it’s amazing.Well done. as we know that “hard work always pays off”,
web designing india
Post a Comment