Hi,
I need to get the monthwise total sales summary in column G based on the data updated in column A&B. Please help.
Thanks.
Hi,
I need to get the monthwise total sales summary in column G based on the data updated in column A&B. Please help.
Thanks.
=sumproduct(--(month(a3:a28)=month(f3)),b3:b28)
Ben Van Johnson
Try below formula and copy towards down
or use pivot tablesPlease Login or Register to view this content.
see attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks