Yes, that's right. Basically, I want to perform a countif(range,value)
divided by a count(range) then multiply the result by the page total, but I
want to do this for several columns to obtain the total number of pages, but
I'm not sure a single formula can manage that........
"JE McGimpsey" wrote:
[Quoted Text] > I find your problem setup a bit ambiguous - with 8 pages in A1 and 8
> rows of {1, 2, or 3}. What if A1 contained 23? Are all 8 rows filled in
> every column?
>
>
> In article <8D3D4076-3208-4CA6-800D-939CE574EFF7[ at ]microsoft.com>,
> "Carl" <carl.ball.removethisbit[ at ]littlewoods.co.uk> wrote:
>
> > Hi - I'm trying to sum the results of calculations across several cells as
> > follows....
> >
> > cells A1 to H1 contains numbers of pages
> > cells A2:H9 contain values 1,2, or 3 that represent types
> >
> > I want to determine how many pages there are of each type, for instance in
> > column A if the first cell contains 8, and the next 4 cells contain 1, the
> > and the last 4 contain 2,2,3,3 then type 1 should equal 4 pages, and types 2
> > and 3 should equal 2 each.
> > Can anyone help?
> >
> > Carl
>
|