| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column sums
Hi all I have two columns of data G and H. I want a formula that will sum th numbers column G BUT only those numbers where there is nothing next t it in Column H. Is this possible? Many thanks. Ji -- 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
=SUMPRODUCT(--ISBLANK(H1:H1000),G1:G1000) -- Regards Frank Kabel Frankfurt, Germany jim27 wrote: Hi all I have two columns of data G and H. I want a formula that will sum the numbers column G BUT only those numbers where there is nothing next to it in Column H. Is this possible? Many thanks. Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to Use when compare sums another column | Excel Worksheet Functions | |||
| 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 | |||
| How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
| Moving Column Sums to Rows | Excel Discussion (Misc queries) | |||
![jim27[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
