Since you mentioned totaling "E and/or F",
how about assigning particular cells to contain your variable criteria.

Say,
G1 = Date (text)
G2 = Name
G3 = E (to sum Column E)
G4 = F (to sum Column F)

And try this formula:

=SUMPRODUCT((C2:C100=G1)*(D2:D100=G2)*((G3="E")*E2 :E100+(G4="F")*F2:F100))

You must make sure that G1 and G2 match *exactly* with the data in Columns C
and D.

Either G3 or G4 may be left blank to total only one or the other of the
columns.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ken8795" wrote in
message ...

Pardon my inexperience please but I am looking for what seems would be a
fairly simple formula, however have thus far had no luck. I have a
workbook that has data saved as follows...

Column C is a TEXT field with a Month/Yr (JAN06, FEB06 etc)
Column D is a TEXT field with a Name
Column E is a NUMERIC field
Column F is a NUMERIC field

The worksheet can contain multiple rows with the same MONTH/YR and/or
NAME.

This file is generated from my billing system. The number of rows is
not static. What I want to do as an example is to SUM the value (E)
and or (F) by "Month" (C) (Text) for all with the same name (D) in a
single cell within another Workbook.

My intention is to be able to run and save the report from my billing
system and have the separarate worksheet to summarize the data.

Any assistance would be greatly appreciated!


--
ken8795
------------------------------------------------------------------------
ken8795's Profile:
http://www.excelforum.com/member.php...o&userid=36411
View this thread: http://www.excelforum.com/showthread...hreadid=561851