PDA

View Full Version : Counting when there are 2 criteria


TamaraNewcombe
Mar 11, 2008, 10:11 AM
In a spreadsheet, how do I get a count total if there are two criteria? For example, in one column I want to count all the "1"'s if, in another column there is a "c".

ScottGem
Mar 11, 2008, 10:13 AM
Read up in Excel Help on Microsoft Query. You can use ths feature to do more complex queries of your data.