Excel 2003 multiple criteria
 

I am trying to add numbers in column H IF the data in column E=AS FIN AND the
data in column B=Jan

I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.

Thanks for any help you can provide.

Excel 2003 multiple criteria
 

Is this what you want?

=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))


"anike007" wrote:

I am trying to add numbers in column H IF the data in column E=AS FIN AND the
data in column B=Jan

I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.

Thanks for any help you can provide.

Excel 2003 multiple criteria
 

Hmmmm - I've tried SO many things but I can't seem to get anything to work....


I tried this but come up with a #Value! answer?!?!?!?!?

Toppers wrote:
Is this what you want?

=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))

I am trying to add numbers in column H IF the data in column E=AS FIN AND the
data in column B=Jan

I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.

Thanks for any help you can provide.

Excel 2003 multiple criteria
 

Check for #Value! errors in E1:E100l and B1:B100.

Check for non-numeric entries in H1:H100.

anike007 wrote:

Hmmmm - I've tried SO many things but I can't seem to get anything to work....

I tried this but come up with a #Value! answer?!?!?!?!?

Toppers wrote:
Is this what you want?

=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))

I am trying to add numbers in column H IF the data in column E=AS FIN AND the
data in column B=Jan

I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.

Thanks for any help you can provide.

--

Dave Peterson

Excel 2003 multiple criteria
 

URGH!!!! So frustrating. Still not working.... ??? :-(

I've checked everything I know to check?? Thanks for trying!

Dave Peterson wrote:
Check for #Value! errors in E1:E100l and B1:B100.

Check for non-numeric entries in H1:H100.

Hmmmm - I've tried SO many things but I can't seem to get anything to work....

[quoted text clipped - 10 lines]

Thanks for any help you can provide.


--
Message posted via http://www.officekb.com