I am needing to total the data in a column only if certain fields equal the correct representative's name in that row. For example:
If C2, C5, C12 and C33 = Todd, AND E2, E5, and E12 have any data entered THEN total the amounts in G2, G5, and G12 (but not G33 because E33 was an empty cell).
What formula would help me accomplish this?
Thanks!
Bookmarks