Posted to microsoft.public.excel.misc

bubble

external usenet poster

Posts: 2

sumproduct or other formula?

i would like to be able to sum the following according to column A's value

mar 100
april 200
may 300
june 400

if i have a cell that has may, i would like another cell to add up anything
from before, example, may will be 600, april will be 300, and june will be
1000.

Thank you.

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
Find value in array	Brook6	Excel Worksheet Functions	26	January 30th 07 09:40 PM
Array formula and multiplying conditions	KR	Excel Worksheet Functions	6	September 22nd 06 12:33 AM
SumProduct Formula Help	bountifulgrace	Excel Worksheet Functions	2	May 4th 06 08:14 PM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
adding two sumproduct formulas together	ski2004_2005	Excel Worksheet Functions	1	November 12th 04 09:08 PM

All times are GMT +1. The time now is 12:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us