Summing categories from multiple table and creating an monthly report

Start Date Jan. 01, 2019
End Date Jan. 20, 2019


TALBE A TALBE B TALBE C
DATE CATEGORY VALUE DATE CATEGORY VALUE DATE CATEGORY VALUE
Dec. 21, 2019 Apple $20.00 Dec. 21, 2019 Apple $20.00 Dec. 21, 2019 Apple $20.00
Dec. 09, 2019 Orange $50.00 Dec. 09, 2019 Orange $50.00 Dec. 09, 2019 Orange $50.00
Nov. 20, 2019 Apple $20.00 Nov. 20, 2019 Apple $20.00 Nov. 20, 2019 Apple $20.00
Nov. 01, 2019 Orange $50.00 Nov. 01, 2019 Orange $50.00 Nov. 01, 2019 Orange $50.00
Oct. 24, 2019 Apple $20.00 Oct. 24, 2019 Apple $20.00 Oct. 24, 2019 Apple $20.00
Oct. 13, 2019 Orange $50.00 Oct. 13, 2019 Orange $50.00 Oct. 13, 2019 Orange $50.00
Sep. 24, 2019 Apple $20.00 Sep. 24, 2019 Apple $20.00 Sep. 24, 2019 Apple $20.00
Sep. 05, 2019 Orange $50.00 Sep. 05, 2019 Orange $50.00 Sep. 05, 2019 Orange $50.00
Aug. 26, 2019 Apple $20.00 Aug. 26, 2019 Apple $20.00 Aug. 26, 2019 Apple $20.00
Aug. 17, 2019 Orange $50.00 Aug. 17, 2019 Orange $50.00 Aug. 17, 2019 Orange $50.00
Jul. 29, 2019 Apple $20.00 Jul. 29, 2019 Apple $20.00 Jul. 29, 2019 Apple $20.00
Jul. 10, 2019 Orange $50.00 Jul. 10, 2019 Orange $50.00 Jul. 10, 2019 Orange $50.00
Jun. 21, 2019 Apple $20.00 Jun. 21, 2019 Apple $20.00 Jun. 21, 2019 Apple $20.00
Jun. 02, 2019 Orange $50.00 Jun. 02, 2019 Orange $50.00 Jun. 02, 2019 Orange $50.00
May. 26, 2019 Apple $20.00 May. 26, 2019 Apple $20.00 May. 26, 2019 Apple $20.00
May. 14, 2019 Orange $50.00 May. 14, 2019 Orange $50.00 May. 14, 2019 Orange $50.00
Apr. 25, 2019 Apple $20.00 Apr. 25, 2019 Apple $20.00 Apr. 25, 2019 Apple $20.00
Apr. 06, 2019 Orange $50.00 Apr. 06, 2019 Orange $50.00 Apr. 06, 2019 Orange $50.00
Mar. 23, 2019 Apple $20.00 Mar. 23, 2019 Apple $20.00 Mar. 23, 2019 Apple $20.00
Mar. 18, 2019 Orange $50.00 Mar. 18, 2019 Orange $50.00 Mar. 18, 2019 Orange $50.00
Feb. 27, 2019 Apple $20.00 Feb. 27, 2019 Apple $20.00 Feb. 27, 2019 Apple $20.00
Feb. 08, 2019 Orange $50.00 Feb. 08, 2019 Orange $50.00 Feb. 08, 2019 Orange $50.00
Jan. 20, 2019 Apple $20.00 Jan. 20, 2019 Apple $20.00 Jan. 20, 2019 Apple $20.00
Jan. 01, 2019 Orange $50.00 Jan. 01, 2019 Orange $50.00 Jan. 01, 2019 Orange $50.00

ANNUAL VALUE TOTALSUM
JAN FEB MAR APR MAY JUN
Apple TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL
Orange TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL
JUL AUG SEP OCT NOV DEC
Apple TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL
Orange TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL

Ok I was able to attach the file. I tried earlier, it wasn't working before. But this is basically what I've been trying to figure out.


I have multiple data sheets, and I need to create a monthly sum for APPLE & ORANGE for the
month of JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC


E.g.

APPLE & ORANGE JAN: 120
APPLE & ORANGE FEB: 160
APPLE & ORANGE MAR: 80

apple.PNG