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.

thanks
excel-question-2.PNG
KoolAsIceAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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
0
 
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.
0
All Courses

From novice to tech pro — start learning today.