Gordon Cooper
New Member
Joined: Nov 22, 2023
Follow
RE: Two tables - formula needed (link provided to Excel file with examples and questions)
=SUMIFS(B3:B17,F3:F17,"notebook") for Irene =SUMIFS(c3:c17,F3:F17,"notebook") for John Swap "notebook" for "desktop" in lower Q's
1 year ago
RE: Two tables - formula needed (link provided to Excel file with examples and questions)
=SUMIFS(B3:B17,F3:F17,"notebook") for Irene =SUMIFS(c$3:c17,F$3:F$17,"notebook") for John Swap "notebook" for "desktop" to get desktop total
1 year ago