Hello again,
I've got rows of data which have a mixture of numbers and percentages which I need to sum. The percentages are every other column and I don't want them to be inlcuded in the sum. What I did to get the addresses for the cells I wanted summed was to write a piece of code that gave me a string that I could paste e.g. A1,C1,E1,G1 ETC
This is fine and it worked OK but I want to know if there's a forumla I could use instead. I was trying for a while to use SUMIF with the CELL function to look at the number format and see whether it was a percentage or not but coulsn't get it to work.
Does anyone have any ideas on a formula for this as it would be a hell of a lot nicer than using VBA?
Thanks
Nick
I've got rows of data which have a mixture of numbers and percentages which I need to sum. The percentages are every other column and I don't want them to be inlcuded in the sum. What I did to get the addresses for the cells I wanted summed was to write a piece of code that gave me a string that I could paste e.g. A1,C1,E1,G1 ETC
This is fine and it worked OK but I want to know if there's a forumla I could use instead. I was trying for a while to use SUMIF with the CELL function to look at the number format and see whether it was a percentage or not but coulsn't get it to work.
Does anyone have any ideas on a formula for this as it would be a hell of a lot nicer than using VBA?
Thanks
Nick