User Profile
Jon_Morgan1958
Copper Contributor
Joined Apr 10, 2020
User Widgets
Recent Discussions
- 453Views0likes0Comments
Select Worksheets by Tab Colour
Hi. I need some help please? My file is organised by WSheet Tab Colour. I need to be able to select all by Tab Colour or some other criteria. Alternately by some other method such as creating a list and then selecting that list to loop thru. Any help much appreciated. Regards JonSolved550Views0likes2Comments- 1.9KViews0likes4Comments
- 744Views0likes0Comments
SumIfs
Ver 2016 Hi I am using SumIf to return results matching criteria between 2 dates. My formula is (SUMIFS(Amount,Group,"=Shopping",Date,">=01/04/20",Date,"<=30/4/20"))*-1 I would like to use a named cell as the 2 dates ie “Apr_Start” “Apr_End” I think my problem is a simple newbie syntax error but try as I might I cant find it. My other question is as a newbie I am still exploring modern Excel, is this the best method to get my data please? Jon779Views0likes1Comment
Recent Blog Articles
No content to show