Forum Discussion
Solved
use SUMIF for cell in immediate row above
Can someone please help me?
I've been using this formula for 2 years and now I need to add another word and row/path to the filter (not sure of correct terminology)
=SUMIF($B$2:$B$6,"Tithes*",$G$2:$G$6)
Now, I need to add OR "processing*" to "tithes" and it can only be for processing fees in the row directly below tithes & offerings.
If "processing*" is in a cell directly below a "tithe*" cell, then it should be included in the formula in K25. (I can figure out K26 & K27 if I can get K25.)
Can someone please help me create the correct formula? I would be extremely grateful!
I recommend use of the SUMIFS function instead (note the S on the end). See the attached workbook.
I think SnowMan55 took care of me. Thank you!
To sum the amounts in column G based on specific conditions in column B, you can use the SUMPRODUCT formula. The goal is to include amounts where the description starts with "Tithes" or where the description starts with "processing" but only if it is directly below a "Tithes" entry.
The formula checks for these conditions by analyzing the first few characters in each cell. It first looks for entries that begin with "Tithes" and adds them to the total.
Then, it checks if a cell starts with "processing" and is located right below a "Tithes" entry. If both conditions are met, the corresponding value in column G is included in the sum. The SUMPRODUCT function is used to multiply the resulting matches by the values in column G and then sum them up. Make sure to adjust the cell ranges in the formula to match your actual data
Thank you for explaining. TBH, it's a little above my excel knowledge. :(
I've found an answer though. Thanks again for taking the time for me, I really do appreciate it.
I recommend use of the SUMIFS function instead (note the S on the end). See the attached workbook.
Amazing! You are amazing! It worked! I would've never figured all that out! Thank you so much!
I still have one question, but I'm not prepared to ask you yet because I'm waiting on clarification about the fees. I know I would like to include an additional cell at the bottom showing the total processing fees to be paid upon receipt of the bill. I don't understand why it looks the way it does on this spreadsheet (downloaded from their site)?! It's very confusing.
Anyway, I'm waiting on clarification about the data and will message you as soon as I can.
I went ahead and attached the file so it's easier to see.
FYI, I began at row 7 because I'm transitioning from one online giving platform (Subsplash) to another (Amplify) and need to combine both platforms in the spreadsheet until we've completely transitioned. The new company uses the processing fee line whereas the other company didn't.
Can you please attach a sample file or share via OneDrive or Dropbox?
