Posted to microsoft.public.excel.programming

Sean

external usenet poster

Posts: 208

SUMPRODUCT OR SUMIF

Want to sum by using four criterias two being numbers and two being
alphabetic all on a seperate worksheet from the one gathering the information
within a range of cells. IF A2:A4 = "111" and IF B2:B4 = "AA" and IF C2:C4 =
"999" and IF D2:D4 = "BB" THEN SUM E2:E4.

This seems complicated to me and I cannot resolve it. If anyone can help
please let me know... Thanks...

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
SUMIF with SUMPRODUCT	WildWill	Excel Discussion (Misc queries)	2	September 14th 09 05:01 PM
sumproduct or sumif I need help, Thank you	Eduardo	Excel Discussion (Misc queries)	4	September 26th 08 02:12 PM
SumIf or SumProduct	[email protected]	Excel Worksheet Functions	8	February 13th 07 06:40 PM
Help for sumif / sumproduct	jitu_tikili	Excel Worksheet Functions	5	April 4th 06 06:59 PM
SUMIF or SUMPRODUCT or something else?	\|\| cypher \|\|	Excel Worksheet Functions	7	November 9th 04 10:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us