Posted to microsoft.public.excel.worksheet.functions

Roberto Villa Real Roberto Villa Real is offline

external usenet poster

Posts: 3

Advanced Criteria for SUMIF

I need to sum some values in Column C, but with 2 criterias (one criteria for
column A and another criteria for column B).

Exemple:
I need the SUM of values in column C, only if Column A="x" AND Column
B="09/03/05"

A______B__________C____

x____09/03/05_____2.99(*)
j____09/03/05_____10.34
y____09/03/05_____1.78
h____12/03/05_____9.21
x____09/03/05_____5.6(*)
x____10/04/05_____22.5
a____05/05/05_____50.02

Total: (2.99 + 5.6) = 8.59

Hope someone helps me!
Thanks a lot!

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
Advanced filter criteria	Marvin Buzz	Excel Discussion (Misc queries)	2	May 23rd 08 02:37 PM
Advanced Sumif formula	Eva	Excel Worksheet Functions	7	June 30th 07 02:04 AM
Summing certain criteria - Advanced	IntricateFool	Excel Discussion (Misc queries)	6	June 19th 07 06:29 PM
Advanced filter criteria	Phil C	Excel Discussion (Misc queries)	4	April 10th 07 07:48 AM
Advanced Filtering - Computed Criteria	KIM	Excel Worksheet Functions	5	February 28th 05 08:31 PM

All times are GMT +1. The time now is 09:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us