Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Arguments - New Twist
Hi to all, Biff helped me wonderfully with a similar problem a few minutes ago. This is so similar but the same function will not work. I'm using this formula =COUNTIF(D6:D11,"0")*1495 to calculate tuition for grades 1-12 if they are local students. If D6:D11 contains numbers 1-12, and the Adjacent column E6:E11 contains the word "Local", I want it to multply by 1495. What formula will check for these two arguments? Thanks to anyone who can help Dan -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=520960 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count occurances of multiple arguments | Excel Discussion (Misc queries) | |||
how do I count with multiple arguments | Excel Worksheet Functions | |||
multiple "if" arguments | Excel Discussion (Misc queries) | |||
Multiple vlookup arguments | Excel Worksheet Functions | |||
Summing across multiple sheets with a twist | Excel Worksheet Functions |