Array Formula in VBA - ExcelBanter

Posted to microsoft.public.excel.programming

gitcypher[_25_] gitcypher[_25_] is offline

external usenet poster

Posts: 1

Array Formula in VBA

If you want to count the number of cells that meet the 100 to 20
criteria,
=COUNTIF(A1:G1,"=100")-COUNTIF(A1:G1,"200")

If you want to add the numbers,
=SUMIF(A1:G1,"=100")-SUMIF(A1:G1,"200")

-gitcyphe

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Array formula: how to join 2 ranges together to form one array?	Rich_84	Excel Worksheet Functions	2	April 1st 09 06:38 PM
Find specific value in array of array formula	DzednConfsd	Excel Worksheet Functions	2	January 13th 09 06:19 AM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM

All times are GMT +1. The time now is 07:35 AM.

Menu

About Us