I have a column with patients' weights in for my research.
I want to tally up the number of patients with a weight >=80 kg but < 100 kg.
I am unable to write a suitable COUNTIF equation!
I know this is really basic stuff but any help would be much appreciated!
Andrew
You can use a sumproduct formula:
=Sumproduct((A1:A10>=80)*(A1:A10<=100))
- Portuga
There is no such thing as a problem, only a temporary lack of a solution
In formulas,you might need to replace ; with , depending on your XL version
Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks