Excel Data Analysis Formula
Budget: $30 – $250 AUD
I am building a reporting dash board
There are two tabs in the dashboard workbook - one for data input and one for dashboard presentation.
I am having trouble determining formulae syntax for a sumif/index/match query on the dashboard tab that is drawing from the data input tab.
Can you help? I just need the formulae and i can finalise from there.
Cell I8 on the attached file contains the formulae that i need help with.
There are two tabs in the dashboard workbook - one for data input and one for dashboard presentation.
I am having trouble determining formulae syntax for a sumif/index/match query on the dashboard tab that is drawing from the data input tab.
Can you help? I just need the formulae and i can finalise from there.
Cell I8 on the attached file contains the formulae that i need help with.