You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Trying to get the daily prices from Table 1 into a sheet like the example in Table 2 (daily price sheet)
SUMIFS unfortunately adds up the 2 totals when there is 2 data points in Table 1
MacBook Air 13″, macOS 14.5
Instead of SUMIFS consider using AVERAGEIFS. MINIFS or MAXIFS should also work.
SG
Needing to get individual daily data from one sheet without adding the data together
