question on post #4:
if that is the case, why isn't the value in cell E14 of your spreadsheet 10341.2? as i understand per your comment above, you want to add all "Base" prices up and show that value against "Core", similarly for "Incre". there is something more to the logic than that, i have a hunch...
- 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 -
Hello,
Thanks for reply.
Because i want to sum all Base who have group = Y and all Incre who have group = Y and put that SUM in corresponding CORE row i.e. Sum should be only in Core- Base and Core- Incre. and All other rows that were added to this sum should be 0. and the ones that are not used in SUM should be kept as it is.
Price 200 for last base is not added because Group = N for this row.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks