Sumif with multi workbooks

Post Reply
bobq880
Posts: 1
Joined: Tue Feb 10, 2026 12:13 am

Sumif with multi workbooks

Post by bobq880 »

How can I enter a formula using sumif that uses a second workbook? Example:
=SUMIF([workbook2]'Checking transactions2506'!E1:E110,B5,'[workbook2]Checking transactions2506'!C1:C110)
What is the proper syntax for referencing the second open workbook2?
Top
Post Reply

Return to “FreeOffice PlanMaker 2024 for Windows”