Remember Me?

#### Menu

#1
 yak10 Posts: n/a
SUMIF function

None of these are working for me, I'm pretty sure that sumproduct is not
what I want. This has to be a logical function. Sumproduct is not a
logical function. I think Ashish is on the right track but it keeps
coming back as either 0 (when it should be 200 from my original post)
or #VALUE error. I need the sum of a column if 2 conditions are
fulfilled.

Ashish Mathur Wrote:
Hi,

Array entet the following formula (Ctrl+Shift+Enter)

=SUM(IF((A2:A6=A8)*(B2:B6=1),C2:C6))

You can also use the DSUM function.

Regards,

"yak10" wrote:
-

Hi everyone, first post for me,

I have been using the sumif function the last couple days and I've
was
wondering if there is anyway to have more than 1 range and criteria
for
this function or is there another function where I can do this?
Below
might better illustrate what I'm trying to do:

Column 1 Column 2 Column 3
Blue One 100
Blue One 100
Red One 100
Red Two 200

I want the sum of column 3, if column 1 equals blue AND column 2
equals
One. So my answer in this case is 200.

--
yak10
-

--
yak10
 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post yak10 Excel Worksheet Functions 3 February 12th 05 01:15 AM Frannie21 Excel Worksheet Functions 4 January 27th 05 03:28 PM Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM [email protected] Excel Worksheet Functions 3 December 17th 04 06:27 PM BMWPRO Excel Worksheet Functions 1 December 6th 04 08:26 PM

All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright ©2004-2023 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"