LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default sumif? array enter?

Hi all,

I want to sum in column F those cells for which in their row one or more
cells in the range AK:AO is not empty.
I tried but did not succeed. Possibly whith an array entered formula? (not
VBA)
Your help will be appreciated.

Jack Sons
The Netherlands


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array formula SUMIF with 2D sum_range array Rich_84 Excel Worksheet Functions 3 April 3rd 09 10:46 PM
I can't enter an array in Excel 2007 dy Excel Discussion (Misc queries) 0 December 8th 08 09:40 AM
I can't enter an array in Excel 2007 dy Excel Worksheet Functions 2 December 5th 08 04:45 PM
enter doesn't work with sumif Infrascanner Excel Worksheet Functions 1 January 27th 06 04:32 PM
Proper way to enter array formula Phil Excel Worksheet Functions 3 October 20th 05 02:44 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"