Overview
Characters
Class Level 1-19 Level 20-29 Amazon formula1 formula2 Barbarian formula3 formula4
Class Level Amazon 15 Barbarian 28 Barbarian 23 Amazon 21 Barbarian 15
Overview (end results)
Class Level 1-19 Level 20-29 Amazon 1 1 Barbarian 1 2
This is the formula I tried for the formula1, but no luck...
Please Login or Register to view this content.
Last edited by nonterrorist; 08-07-2012 at 09:09 PM.
Hi
Assuming that your data as above is in the range A1:B6, and the output table is in the range D1:F3 the
E2: =SUMPRODUCT(--($A$2:$A$6=D2),--($B$2:$B$6<20))
F2: =SUMPRODUCT(--($A$2:$A$6=D2),--($B$2:$B$6>=20))
HTH
rylo
Thank you, worked!
Last edited by nonterrorist; 08-07-2012 at 09:08 PM.
two, more, possible ways:
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks