Forum Discussion
Solved
Available Kms per week
Hi all. I am a coordinator who works with people with disability. One of the sticky problems is tracking available Kms for these participants each week. Commonly these participants are allocated a bu...
You did not adjust the input ranges in the formula.
The input columns are columns G:H, right? Therefore the formula in G3 should be...
=B7-SUMPRODUCT((WEEKNUM(--(G2:G100))=WEEKNUM(B2))*(H2:H100))You may adjust the input ranges G2:G100 and H2:H100 as per your requirement.
I have inserted one new record and the formula returned the balance kms correctly. Please refer to the attached.
You did not adjust the input ranges in the formula.
The input columns are columns G:H, right? Therefore the formula in G3 should be...
=B7-SUMPRODUCT((WEEKNUM(--(G2:G100))=WEEKNUM(B2))*(H2:H100))You may adjust the input ranges G2:G100 and H2:H100 as per your requirement.
I have inserted one new record and the formula returned the balance kms correctly. Please refer to the attached.
Sorry for being so slow in thanking you .I have been away from my laptop. I appreciate your time very much 🙂
- You're welcome Cambosity100!
No worries, that's completely fine.