Forum Discussion
Solved
how to write formula?
Can someone help me? I have no idea how to create a formula that will do this but I know it can be done. Please see text box in the middle of pic. Please help?
=SUMPRODUCT(SUMIFS(K2:K10,F2:F10,"Tithes and offering",J2:J10, {"batched","paid"}))This formula works in my sheet.
=SUMPRODUCT(SUMIFS(K2:K10,F2:F10,"Tithes and offering",J2:J10, {"batched","paid"}))This formula works in my sheet.
- Thank you so much! I see where it worked for your sheet. I have adjusted for the size of my sheet (only 46 rows including headers.) Somehow it's not working how I need it to in mine though.
I have removed all the names (for privacy) from my spreadsheet and would like to share the whole thing with you? Can I do that? I'm sure there's some dumb error but I can't find it or figure it out.
Is there a way to do that?Is it possible to select the highlighted button and send me a message? You can attach a file or a screenshot to the message.
- doing now. ty!
