| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column sums
Comes up with zero as the sum. I think this is because there is formula in all the cells in H. How can I get around this so it jus picks up the numbers? Thank -- jim2 ----------------------------------------------------------------------- jim27's Profile: http://www.excelforum.com/member.php...fo&userid=1537 View this thread: http://www.excelforum.com/showthread.php?threadid=27812 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
column sums
Hi
then try: =SUMPRODUCT(--(H1:H1000=""),G1:G1000) -- Regards Frank Kabel Frankfurt, Germany jim27 wrote: Comes up with zero as the sum. I think this is because there is a formula in all the cells in H. How can I get around this so it just picks up the numbers? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add up sums in column m if column c = scott | Excel Worksheet Functions | |||
| =sum(A:A) add to column (B) and new value repeats w/ new sums | Excel Worksheet Functions | |||
| Help With A Formula That Sums Items In A Column | Excel Discussion (Misc queries) | |||
| How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
| column sums | Excel Programming | |||
![jim27[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
