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

1. ## 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. ## 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

3. ## 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. ## Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

Hi
welcome to this forum
Check the attached file..

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

Originally Posted by Special-K
=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. ## Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

Originally Posted by Vikas_Gautam
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. ## 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. ## Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

Originally Posted by Punnam
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. ## Re: Fornula needed: Count cells is adjacent cell contains or equals to specific word

Originally Posted by Punnam
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. ## 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

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

#### 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