Meaning of excel formula

Can someone please tell me the what the formula attached as image is doing? Especially, I need to know what Table4 is doing here?

Any help will be highly appreciated.

Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

Rory ArchibaldConnect With a Mentor Commented:
It is adding the event costs from table 4 where the event type matches one of the specified criteria. It also won't work if the source workbook is closed.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

these formulas use a reference to a table that has been created with Insert > Table.

You can toggle back to normal referencing with a setting in the Excel Options. In 2010 it is

File > Options > Formulas > Use table names in formulas

Untick that and the familiar cell references will be displayed in the formulas.

cheers, teylyn
KoolAsIceAuthor Commented:
hi Teylyn,

Thank you so much for your reply. I did try that, but that didn't change anything.

Could you possibly make any sense of these formulas just by looking at them? If you do please let me know.

Thank you so much for your help.
All Courses

From novice to tech pro — start learning today.