Please see below to assist:
Age Books required Total books required for each age grade
1 5
1 7
1 9
5 20
5 15
12 30
12 5
12 14
12 14
12 2
Please see below to assist:
Age Books required Total books required for each age grade
1 5
1 7
1 9
5 20
5 15
12 30
12 5
12 14
12 14
12 2
Hi,
I'm sorry but this makes no sense? Have you got a sheet you could attached with a bit more blurb to explain what you are looking to achieve?
Assuming Age in column A, Book in column B
In A1
=IF(A1=A2,"",SUMIF(A:A,A1,B:B))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks