Ask Experts Questions for FREE Help !
Ask
    kumarm1's Avatar
    kumarm1 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 26, 2009, 12:31 PM
    sumproduct in SPreadsheet
    Hi,

    I want a count of two columns meeting a certain criteria. Below is the example of what I want:

    A B
    Surrender termination
    Surrender payment
    Surrender confirmation
    Maturity termination
    Maturity payment
    Maturity confirmation
    Surrender payment
    Surrender payment
    Maturity o/s letter


    Surrender =5
    Maturity =4

    I want a formula to count the number of times any of the text from Column B (termination, payment, confirmation and o/s letter) comes with Surrender (Column A) and give the count =5 as above and same with Maturity.

    I also want to know if I can do this using sumproduct and will it work in all the version of MS EXCEl.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Aug 26, 2009, 06:54 PM
    This is actually a COUNTIF() formula.

    =COUNTIF(A:A,"Surrender")

    Or if the word Surrender is in a cell next to this formula, you could use:

    =COUNTIF(A:A, B12)
    Attached Files
  1. File Type: xls kumarm1.xls (13.0 KB, 132 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Sumproduct And Excel [ 2 Answers ]

I am trying to make a spreadsheet that will take a date and see that it has a specific dollar amount to it for a specific type of product. IE lets say I want to see how much I spent in January on bagels. I know how to count how many times I bought bagels in July using sum product but I want to...

Getting error in using SUMPRODUCT [ 2 Answers ]

I have a sheet linked to a cell containing SUMPRODUCT formula (like "=SUMPRODUCT(--(dealer_List=A6),(claims_recd),--(Data_List>=$B$2),--(Data_List<=$D$2))". "claims_recd" is NAME i have given to a column and have some basic IF formula for gettng value. I am getting "0" value in the cell which...

SpreadSheet Printing [ 2 Answers ]

I am using Excel 2007 I have number of Items in my dropdown list and I need to take a print out of every item from the list. Is there any way to give just one print command and the entire list gets printed one by one instead of selecting each item separately and giving a print command.

No spreadsheet [ 4 Answers ]

I have a new computer with windows vista. There is no spreadsheet with it like there used to be on computers. Is there a free way to get a spreadsheet system in my computer. I use spreadsheets some but not enough for me to buy anything to get it to work.

View more questions Search