sum range

It's been 2 weeks now since I started a mini project but my clogged brain won't cooperate with me :) I hate to burden but can anyone help me, given the sample data I would like to merge all Med Category and its corresponding grams and value (number of Med per Unique Numbers Varies) I hope I...

Hey guys, I have looked online and have found some similar questions related to this, but nothing I have found seems to work. I am trying to use a SUMIF statement on a large collection of data. For the most part, it works just fine. However, if there ever happens to be a blank cell in the...

Hi All Good people I'm new to VBA and I'm seeking some assistance with a macro. I have a workbook with multiple sheets. First worksheet is call master worksheet. In the master worksheet I have sheet names. I would like to sum all cells below a specific column header named, "My text." across all...

I need to sum a range of cells to a max count of 25 cells, but don't start counting until cell has a value greater than $0. Values may start in any year/row Ex <colgroup><col width="64" style="width: 48pt;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt...

Hi All, I have an issue that I am hoping someone can help me with. <tbody> 31/10/2017 Manual Entry Orange Manual Entry 31/07/2017 31/08/2017 30/09/2017 31/10/2017 30/11/2017 Apple 65,906.16 64,208.91 60,553.10 61,147.29 (65,168.44) Orange 82,423.36 79,439.45...

I have an expense report, and I want to sum the amount that does not equal a range of text, i.e. Description Amount Category misc.item $20.32 Gas misc.item $10.20 Food misc.item $5.68 Snacks misc.item $40.00 Gas misc.item $6.48 Food misc.item $32.78 Gas...

I am trying to create a formula that will sum a range based on both horizontal and vertical criteria using the following data: <tbody> 1 2 1 20% 25% 2 40% 25% 3 40% 50% </tbody> For example, if the horizontal criteria were "1" and the vertical criteria were "2", I need to sum the...

Is there a way to check a range for null or zero value. I need to update large ranges but only if there is no data or if the values are zero. I was thinking of something like: If IsNull(Range(Cells(1,1), Cells(10,10)) or If Sum(Range(Cells(1,1), Cells(10,10))) = 0 Any thoughts?

Hey everyone...I've trawled around the site but can't find an answer to my specific problem. Hopefully someone can help! I would like to calculate the Year To Date total without having to manually adjust the sum range. For instance in Jan the YTD calc is just col M; in Feb the YTD calc is...

I have a range of numbers in a row that consist of both positive and negative numbers. I would like excel to locate the first positive number and start adding all the number then after including that first positive number. Does anybody have a solution for me. -$7,514,205,-$91,005, -$91,005...

I'm hoping someone can help. I'm trying to sum a range in A1 and then based on that range, A2 will sum the same columns, but one row down. Added to this I want to be able to link B1 to A1 but to sum starting 12 columns later (i.e. every 12 months). The reason I'm not just filling down A1 to...