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
|