Justine Burn via OfficeKB.com

Posts: n/a

Adding the sum of figures in one column if they meet 2 criteria

Please help! I have a column of 500 figures. I want to calculate the total
value of all figurews between 10000 and 12000 in the column at the bottom
of the page. What do you recommend? Currently i have the following but it
is not working. =SUM(IF(D3:D151,"10000")*AND(D3:D151,"<12000")).

--
Message posted via http://www.officekb.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
Adding more than 30 numbers in a column	CLR	Excel Worksheet Functions	12	February 20th 05 08:05 PM
Adding a KeyID column for sorting	Rebecca	New Users to Excel	3	February 20th 05 07:09 PM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON.	Robin Smith	Excel Discussion (Misc queries)	0	December 20th 04 08:47 PM
macro - adding rows to a column that is summed	HGood	Excel Discussion (Misc queries)	2	December 1st 04 03:28 PM
Adding column data	stge	Excel Worksheet Functions	1	November 4th 04 05:26 PM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us