count conditionally across two columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a runing total of how often conditions in two ciolumns are met. for
example, how often is column A > 45 and column B < 100 in my data?
 
Hi

Try entering in C1
=SUMPRODUCT(--($A$1:A1>45),--($B$1:B1<100))
Copy down column C as far as required.

Regards

Roger Govier
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Condition - search 2
Returning 1 of 4 values if conditions are met 4
Conditional formulas 1
sum if conditions in two columns are met? 4
Conditional count 2
Excell - two conditions count if factors are true when negative nu 2
Cell value when conditions are met 8
sumproduct with 4 conditions 1

Back
Top