How to calculate text in incremental steps

  • Thread starter Thread starter andrew
  • Start date Start date
A

andrew

Hi there. How do i use a formula in a cell to calculate the following
conditions:

Column A = "H" text
Column B = "W" text

It requires both text to appear on the same row before equating it with a
numerical value of 1. Whenever a new row is created, and both "H" and "W"
appears (in column A and B respectively) in the same row, the cell will have
a function to add up to the total number of times a row has both text.

Sorry if the above sounds silly but i'm pretty new to Excel.
 
=SUMPRODUCT(--(A2:A11="H"),--(B2:B11="W"))
Change 11 to max No of your actual rows or max Excel row (in Excel 2003 it
is 65536, in Excel 2007 you can refer to entire columns: A:A, B:B)

Regards,
Stefi


„andrew†ezt írta:
 

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

Scrabble Value calculation for Welsh words 0
Excel Typed text appears in wrong cell 0
Comparison of columns using Conditional Formatting 3
using the =page! feature to transpose a row to column 0
Drag without incrementing 2
sumproduct - find text in string 11
SumPRODUCT - calculating result?? 5
Calculate Monthly Inventory Usage 5

Back
Top