Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells with Multiple Range Criteria (Excel 2003) | Excel Discussion (Misc queries) | |||
Search for one answer on multiple criteria (excel 2003) | Excel Worksheet Functions | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
Counts for Excel 2003 using multiple criteria | Excel Worksheet Functions | |||
Select by multiple criteria (Excel 2003) | Excel Worksheet Functions |