Using countif statements

canadacom

New Member
Joined
Nov 15, 2005
Messages
2
I want to know if I use a countif statement to count the range of values in column A =COUNTIF(A5:A564,"<=3" can I also combine another countif statement to count the range of percentages in column B =COUNTIF(B5:B564,">=100%") The reason is the first statement is counting how many widgets were sold. The second statement counts the widgets sold versus the sales goal resulting in a percentage. IF you do not count them together you cannot break them down into categories such 0-3,4-5,6-8,9-+,etc..

HELP!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,118,079
Messages
5,570,080
Members
412,310
Latest member
mark884
Top