URGENT: Advanced Excel Summary

[catbebe]

This formula is working and returned with correct value
=SUMIF(RAW!C:C,5,RAW!D)

However, I have another criteria would like to add in, which is:
(RAW!O:O="2B4AE01W")

I tried both below but not working
=SUM(OR(RAW!C:C=5),(RAW!O:O="2B4AE01W"),(RAW!D))
and
=SUM(AND(RAW!C:C=5),(RAW!O:O="2B4AE01W"),(RAW!D))

Please help~~

Urgent ~~ ~~ report due to deadline of submission ~~

Many thanks.
Cat =^.^=

 

[GlennUK]

For multiple cases, use SUMPRODUCT with boolean logic, like this:


=SUMPRODUCT((RAW!C1:C65535=5)*(RAW!O1:O65535="2B4AE01W")*(RAW!D165535))

Note: you cannot use entire column references in this formula.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

By the way, putting URGENT in your topic heading makes people less likely to answer your post. Count yourself lucky so far ( I've mentioned this for the benefit of others who may think this tactic is worth using ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

you may also want to check the FAQ area before asking a question.....

How do I count records when I have more then one criteria? faq68-4725

Would also like to second Glenn's point - why do you feel you have the right to demand help by using words such as "Urgent" in your thread title ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SilentAiche]

Not meaning to pile on, but Tek-Tips also has a terrific "STAR" system whereby beneficiaries, such as you and me, can let helpful members know that their contributions were helpful.

I personally have awarded 100 STARS in the 301 days since I discovered this amazing place.

I notice, however, that you've been a member here for 766 days and, somehow, have never given ANYONE a STAR.

I most gently suggest you work on that.

Tim

[blue]______________________________________________________________
I love logging onto Tek-Tips. It's always so exciting to see what the hell I
said yesterday. [/blue]