+ Reply to Thread
Results 1 to 10 of 10

Fornula needed: Count cells is adjacent cell contains or equals to specific word

  1. #1
    Registered User
    Join Date
    09-30-2014
    Location
    USA
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Fornula needed: Count cells is adjacent cell contains or equals to specific word

    Hi guys,

    I am trying to figure out if there is any kind of formula I can use to solve my problem.

    Say I have an expense ledger in excel format. I have cells with "Check total:" and I have a cell next to this cell with the amount of the check. What formula can I use to add all of the amounts that are next to the "Check total:" cell?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    =SUMIF(A1:A10,"Check total:",B1:B10)

    where A1:A10 are text values
    B1:B10 are the amounts to add
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    09-30-2014
    Location
    USA
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    in my case, "Check total:" and the amount are not necessarily aligned, meaning that “Check total:” and the amount are not always in the same column.

    for one of the checks, “Check total:” is in cell B2 and amount in B3, for another check, “Check total:” is in cell F4 and amount is in cell F5.

    I also have rows in-between with additional information of the check that I am not using.

    Is there anything that can be done in this case?

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    Hi
    welcome to this forum
    Check the attached file..
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  5. #5
    Registered User
    Join Date
    09-30-2014
    Location
    USA
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    Quote Originally Posted by Special-K View Post
    =SUMIF(A1:A10,"Check total:",B1:B10)

    where A1:A10 are text values
    B1:B10 are the amounts to add
    in my case, "Check total:" and the amount are not necessarily aligned, meaning that “Check total:” and the amount are not always in the same column.

    for one of the checks, “Check total:” is in cell B2 and amount in B3, for another check, “Check total:” is in cell F4 and amount is in cell F5.

    I also have rows in-between with additional information of the check that I am not using.

    Is there anything that can be done in this case?

  6. #6
    Registered User
    Join Date
    09-30-2014
    Location
    USA
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    Quote Originally Posted by Vikas_Gautam View Post
    Hi
    welcome to this forum
    Check the attached file..
    Sorry, still trying to get used to the forum and how to post things, but there is my issue:

    in my case, "Check total:" and the amount are not necessarily aligned, meaning that “Check total:” and the amount are not always in the same column.

    for one of the checks, “Check total:” is in cell B2 and amount in B3, for another check, “Check total:” is in cell F4 and amount is in cell F5.

    I also have rows in-between with additional information of the check that I am not using.

    Is there anything that can be done in this case?

  7. #7
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    That's fine tatiana4eva ,

    Can you upload a sample workbook with out any confidential data , showing your result manually .

    Punnam

  8. #8
    Registered User
    Join Date
    09-30-2014
    Location
    USA
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    Quote Originally Posted by Punnam View Post
    That's fine tatiana4eva ,

    Can you upload a sample workbook with out any confidential data , showing your result manually .

    Punnam
    Should've thought of that in the beginning. lol
    Here you go. Sorry I could not find how to attach an excel spreadsheet, so I attached a photo of it. thanks!
    Capture.jpg

  9. #9
    Registered User
    Join Date
    09-30-2014
    Location
    USA
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    6

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    Quote Originally Posted by Punnam View Post
    That's fine tatiana4eva ,

    Can you upload a sample workbook with out any confidential data , showing your result manually .

    Punnam
    Should've thought of that in the beginning. lol
    Here you go. Sorry I could not find how to attach an excel spreadsheet, so I attached a photo of it. thanks!
    Attachment 348700

  10. #10
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

    hi,


    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Punnam

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count cells within a specific date range that contain a specific word
    By oneillp1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-23-2014, 08:34 AM
  2. [SOLVED] Formula needed to only count total cells entered and not count adjacent text entered cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2013, 06:22 PM
  3. Replies: 2
    Last Post: 02-27-2013, 11:16 PM
  4. [SOLVED] Return value if any of cells in range equals a specific value (cell)
    By G.Bregvadze in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2013, 07:59 AM
  5. word count within specific cells
    By chuckwag0n in forum Excel General
    Replies: 3
    Last Post: 05-23-2012, 11:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1