Hi all,
I have a data in Table 1 looking like below and I've been trying to get the sum of all May YTD and May YTG amounts (to put in Table 2) for each store by using SUMPRODUCT but i keep getting #N/As.
The formula I came up with is (for example, i want to get the figure for Store A)...