Forum Discussion
use SUMIF for cell in immediate row above
I recommend use of the SUMIFS function instead (note the S on the end). See the attached workbook.
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.