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!

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?

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?

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?

That's fine tatiana4eva ,

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

Punnam

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

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

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