Follow
Any spreasheet wizards here? I'm trying to do something with a combination of VLOOKUP and SUMIFS that's beyond my skill level, and I cannot figure out the syntax to do it after 2 days of trying.
Please let me know if you can help and I'll DM you a screenshot.
@voltronic OK maybe this advice is too simple, but have you tried breaking the SUMIF into its own column to check that that's working properly? Also, is there a string required for specifying that something is a numeric rather than text value? (I've been using VLOOKUP with text rather than numbers for a project.)
@voltronic you may have tried this already, but can you ask an LLM or Alfred to assist? I’ve had success getting complicated formulas that way.
@voltronic
Are you trying to look up results of SUMIFs?