Forum Discussion
Fiona_Myatt
Apr 30, 2024Copper Contributor
Counting cells with formulae in them
I have a spreadsheet where I am entering 3 elements of wages (basic, holidays, overtime) then totalling the gross pay for each week then again over a period of 13 weeks. I need to average what each p...
- Apr 30, 2024
Fiona_Myatt
Copper Contributor
I'm quite an amateur but I'm sure there must be a way!
In column AJ I want to show how many (in this case) fortnights have been worked but it really doesn't like any formula I use as W3, for example, is T3+U3+V3. So when I am trying to put formula into AJ I'm putting =COUNT(W3+AA3+AE3+AI3) but it doesn't like it as it normally wants a range of W3:V3 but that would then include all the columns in between which I don't want.
If you can steer me and tell me where I'm going wrong I'd appreciate any help thank you!
HansVogelaar
Apr 30, 2024MVP
- Fiona_MyattApr 30, 2024Copper ContributorThank you! You're a hero!