Solved

count row in excel if = to 2 conditions

Posted on 2011-02-11
3
334 Views
Last Modified: 2012-08-13
I need to count row P in my excel spreedsheet if row H > 17 and row P = 1 or 3.  

How can I write the query to do this in and excel field.

thanks
0
Comment
Question by:running32
3 Comments
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 500 total points
ID: 34874349

Use this formula...

=SUMPRODUCT((H1:H100>17)*(P1:P100=1)+(P1:P100=3))

Please adjust ranges as per your data...

Saurabh...
0
 

Author Closing Comment

by:running32
ID: 34874498
thank you for the quick answer
0
 
LVL 12

Expert Comment

by:Amick
ID: 34874592
Assuming the range is 1,2,3 then try
=COUNTIFS(H1:H9999,"= 17",P1:P9999,"<4")-COUNTIFS(H1:A9999,"= 17",P1:P9999,"=2")
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question