Search : in
By :

Counting in Multiple columns

Last answer on Sep 29, 2009 10:51:02 am BST Alax, on Sep 29, 2009 6:52:55 am BST 
 Report this message to moderators

Hi All,

I am a new Excel user. Can someone help me in getting solution to below
problem:

I have following data:

Grade Suject1
A 80
B 80
C 50
A 90
B 70
A 80

How can I

1. Count only Grade is "A" and score is "80"
2. Count only Grade is "A" and "B" and score is ">=70"

Thanks, Alax

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Counting in Multiple columns » in :
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Writing in batch in text file ShowWriting in batch in text file To write in a file text, you just have to use a redirect: echo text > output_file.txt To write in an existing file: echo " Write at the end of the file ">> output_file.txt
Renaming multiple files in batch ShowRenaming multiple files in batch Native features Using a third-party program Renaming a large number of files can quickly become tedious. Fortunately, there are tools to automate this task in many cases: Native features On Windows...
Data transmission - Multiplexing ShowIntroduction to multiplexing Multiplexing refers to the ability to transmit data coming from several pairs of equipment (transmitters and receivers) called low-speed channels on a single physical medium (called the high-speed channel). A...
Ask your question Reply

1

 venkat1926, on Sep 29, 2009 10:51:02 am BST

=SUMPRODUCT(($A$1:$A$6="A")*($B$1:$B$6=90))

if it is ok say "yes"

   
Reply to venkat1926
Ask your question Reply
They need your help