| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of multiple IF statements
Thanks Dave - seems to work perfectly
- and Thanks to everyone else - I'm learning loads! "David Biddulph" wrote: "Snap" wrote in message ... Thanks Lance, but this formula counts blank cells eg if K3 and M3 are blank (match not yet played, say) then a result of 1 is given. "LanceB" wrote: =IF(K3=M3,1,0)+IF(K5=M5,1,0) =AND(K3=M3,K3<"",K5<"")+AND(K5=M5,K5<"",M5<"") If you want the answer to be blank until all the match results are entered, then you could use: =IF(OR(K3="",K5="",M3="",M5=""),"",(K3=M3)+(K5=M5) ) -- David Biddulph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
| Multiple If/Or Statements | Excel Worksheet Functions | |||
| combining IF and AND statements for multiple columns | Excel Discussion (Misc queries) | |||
| multiple nested IF statements | Excel Worksheet Functions | |||
| How to: Multiple "if" statements? | New Users to Excel | |||
Threaded Mode
