Quote:
Originally Posted by master3004
Running into a bit of a problem someone might be able to help with.
Attempting to Sum a group of data for multiple columns based on criteria in column A. So If I have the word BLUE appearing on rows 1,7, 18, 27, and 265, and values for each of those appearing in columns B-G, I want the total sum for all instances of BLUE across all columns. I was able to find that this is doable using the sumproduct function within the same worksheet, however, if I attempt to use the same formula on a separate worksheet, I am getting a VALUE error. I am able to use sumproduct and return a result on a separate worksheet using only a single column, but when I attempt to extend this to multiple columns from the original sheet, I get the VALUE error.
Any ideas on if this is doable? I have been searching for a while now, and have found options for single columns and multiple columns as long as the formula appears on the same worksheet, but not for multiple columns with the formula on a separate worksheet.
Thanks
not sure if i can help or not but if you uploaded an image to see what you're describing i may be able to assist
there's a number of ways you may have fouled it up and it's just easier to share images than guess all the possibilities
Quote:
Originally Posted by CrimesNCapers
Basically for any random flop (22,100 flops), and any random hand (1326 hands) ... is it possible to create something in excel that tells you what your hand strength is. Made this picture to show what I am trying to do (automate red column). Maybe its been done before? Thanks.
you could run a bunch of if functions but preferably with VBA
but more importanly, it won't scale. I imagine you're doing this for a large database, once you get beyond a few thousand lines it's going to start grinding to a halt - we're talking several minutes to open the file, several minutes to add some new inputs, several minutes to save the update
I'm thinking R may be better for this, maybe python?