| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum calculation based on condition
HI:
I need to be able to loop though column a & if a condition is true, I need to caculate a sum in based on the value in column m.. I need to be able to display the count of the active cell & the sum of column m & loop though..I have numerous values I have to set this for... I'm trying this & it's not working.. Any help would be greatly appreciated... If ActiveCell.Value = "SPECIALTY CARE" Then SpecCount = x + 1 ' sum = Range("M2:M2", Range("M2").End(xlDown)).Calculate sum = Range("M2:M2000").Formula = "=sum(M2:M2)" I think I've confused myself.... THANK YOU |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
| Fill a cell based on a condition being met | Excel Worksheet Functions | |||
| Change row color based on condition of celss | Excel Worksheet Functions | |||
| Counting Across Multiple Ranges, Based on Condition | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Threaded Mode
