sum range of cells according to condition

[efiboli13]

Hi,

I want to sum the last X cells according to specific condition,
for example if A11>0 then sum A1:A10, else sum A2:A10.


is it possible?

Thanks!

[PeteABC123]

Please Login or Register  to view this content.

Pete

[efiboli13]

Thanks,

I want that the number of the cells to sum while be dynamic,
I mean that if the condition fulfills than it will sum X last cells, and the X number will be set in a different excel sheet.

[JeteMc]

We may be in a better position to help if we could see a sample Excel file that illustrates what you are attempting to accomplish.
Instructions for including an Excel file with your post are given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Let us know if you have any questions.