another sumifs question - help needed to translate to 2003please

[zakee]

Hello,

Ran through your forums - found it very interesting, found few similar problems but cannot do it - somehow doesnt work

please see this formula
=SUMIFS('CS Feedback'!I$5:I$100,'CS Feedback'!F$5:F$100,A4,'CS Feedback'!R$5:R$100,E$3)

no problems in 2010 cant use in 2003 any ideas?
how to translate it?

Regards,
z

 

[T. Valko]

Hello,

Ran through your forums - found it very interesting, found few similar problems but cannot do it - somehow doesnt work

please see this formula
=SUMIFS('CS Feedback'!I$5:I$100,'CS Feedback'!F$5:F$100,A4,'CS Feedback'!R$5:R$100,E$3)

no problems in 2010 cant use in 2003 any ideas?
how to translate it?

Regards,
z

This will work in any version of Excel:

=SUMPRODUCT(--('CS Feedback'!F$5:F$100=A4),--('CS Feedback'!R$5:R$100=E$3),'CS Feedback'!I$5:I$100)

 

[VoG]

Try

=SUMPRODUCT(--('CS Feedback'!F$5:F$100=A4),--('CS Feedback'!R$5:R$100=E$3),'CS Feedback'!I$5:I$100)

 

[zakee]

Thanks for swift reply!

geting #N/A error - is that possible that it is caused because part of my data is text i.e names?

what I'm trying to achieve is:
compare if F column (usernames only)equals A4(also username)
and
compare if R column (text data_ error description) Equals E3
if yes

I have "I" column with 1 or 0 that should be counted when above is True

I can make up some example of what I'm trying to do.

Thanks in advance

 

[zakee]

Hello again!

Thanks so much you've made it work!

looks like it's really sensitive about data... cleaned up a bit -all good now

Thanks a lot!