summing

Is there a way that I can count the number of cells that have a formula? Cell 1: 5 Cell 2: 8 Cell 3: Sum(a1:a2) Cell 4: 2 Cell 5: 9 Cell 6: Sum(a4:A5) I would like a formula that would return 2.

Using the advancedfilter I find rows in my data which have certain criteria. I'd like to make a calculation where i subtract to cells in each of and sum the result. Using the code below creates a loop which runs through all visible cells in all rows. I only need to run through each visible row...

Hello, I have a question. Each month I do a report showing the 3 month and 12 month sales $ and units. Every month I add to my database two columns worth of data. How can I anchor my sum calculation to Column 'P' 'R' 'T'? When I insert two columns my calculation currently moves with the cells...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

I need to collect and sum manhours for an activity for a monthly period of time. Cells A1 thru O1 contain 15 different start dates occurring during a single month for one activity. The activity takes 4 consecutive days to complete and requires 7 manhours on day 1, 6 manhours on day 2, 4...

I have been asked this from one of my co-workers. He wants a formula to add cells from different worksheets (same format, same cell), in different workbooks. i.e. say cell A25 of each worksheet needs to be add up. Thanks in advance.