Forum Discussion
Help with array formula
Hope someone can help me with writing a formula for Microsoft Excel: I have data in the area A3:DP240593. I want the formula to count and sum the number of rows in the area (from 3 to 240953)...
Could you do some clarifying before I or somebody else tries to answer you.
I want the formula to count and sum the number of rows
Is there a reason why you use both "Count" and "Sum" in that request? If so, what is that reason? If not, may we conclude that what you really need is just a count? Or do you want the sum of one or more of the columns in the rows that meet the criteria?
that meet these three conditions:
1) The D cell must say '208000'.
2) The P cell must say '1'
3) At least three of the cells AE, AF, AG, and AH must say either '1' or '2'.
And can you assure us that all of those figures are legitimately numbers? Or are one or more of them text masquerading as numbers?
Is this a spreadsheet that is shareable? That is, would you be willing and able to post a copy on OneDrive or GoogleDrive with a link here that grants access? Or, probably easier, could you post a copy of a representative section of it, just so formulas could be tested against some actual representative data?
mathetes Thanks for your reply. Yes, your first assumption was correct. I'm very new to using Excel with formulas this complex. And yes, actually, a there was text masquerading as numbers, which turned out to be part my problem!
In the end, I decided to just break everything down into three much simpler formulas that did the same thing and with minimal extra manual work by me. So thank for useful the useful hint on text and your precision.
