calcharn
-
Posts
10 -
Joined
-
Last visited
About calcharn
-
Morning I have this formula below working on a spreadsheet. Its that old I cant even remember how i created it. But it works for what i need. I just want to manipulate it to count numbers between 20 and 39, but no matter what I try I cant get it to work. Can anyone help? =SUMPRODUCT(SUBTOTAL(3,OFFSET(AI3:AI875,ROW(AI3:AI875)-MIN(ROW(AI3:AI875)),,1))*(AI3:AI875>=20))
-
it doesnt work, says invalid function
-
excel 2019
-
thanks George for the quick response, but it doesn't seem to want to work for me:(
-
DOES ANY ONE KNOW WHAT FORMULA I COULD USE TO CONCATENATE FOUR CELLS BUT ALPHABETICALLY, so it ends up like the last column [TABLE=width: 500] [TR] [TD][TABLE=width: 168] [TR] [TD=class: xl66, width: 168]History[/TD] [/TR] [/TABLE] [/TD] [TD][TABLE=width: 176] [TR] [TD=class: xl66, width: 176]HOSPITALITY AND CATERING[/TD] [/TR] [/TABLE] [/TD] [TD][TABLE=width: 176] [TR] [TD=class: xl66, width: 176]SPANISH[/TD] [/TR] [/TABLE] [/TD] [TD][TABLE=width: 176] [TR] [TD=class: xl66, width: 176]Photography[/TD] [/TR] [/TABLE] [/TD] [TD]history hospitality and catering photography spanish[/TD] [/TR] [TR] [TD]Maths[/TD] [TD]French[/TD] [TD]Geography[/TD] [TD]Art[/TD] [TD]Art French Geography Maths[/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [/TABLE]
-
Hi AJP233 we have managed to finally extract the file (excel) what row do i need to edit in the VBA
-
This is the error i get when i try to extract?
-
its saying the compressed zip folder is invalid
-
Hi I have a report in sims that produces a list of student names along side their achievement points, behaviour points and then a total (achiev - behav) between two dates. When i run it for just one form it works perfectly, sending the information into excel and then into a pivot table or macro table. Not sure what as its a pre defined report that i can see to open or manipulate. When i try to run it for more than one form or different dates it times out and produces the following error "error 6 overflow" I have tried to google and i believe its something to do with number of rows - but that's where i get totally confused. How do i edit the VBA if i dont know where the sims template is stored? in addition to getting the above up and running i would also like to filter the report to show subject specific points. But again when i ask too much it crashes. can any one help?
