| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel foruma for Exclusive numbers
I need an excel formula. No one can help me, so I'm coming
to you. I need to do an "exclusive" formula in the total column on an excel sheet. For example. If column A4 to A55 has a number greater than 0 in it, then it is exclusive to columns b, c and d and adds up in the total column. And then I have to do the same for the other three columns. Can anyone help me? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel foruma for Exclusive numbers
=Sumif(A4:A55,"0")
-- Regards, Tom Ogilvy Donna wrote in message ... I need an excel formula. No one can help me, so I'm coming to you. I need to do an "exclusive" formula in the total column on an excel sheet. For example. If column A4 to A55 has a number greater than 0 in it, then it is exclusive to columns b, c and d and adds up in the total column. And then I have to do the same for the other three columns. Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mutually exclusive cells - Excel 2003 | Excel Worksheet Functions | |||
| Ranging foruma in excel | Excel Worksheet Functions | |||
| Excel claims exclusive file may have been changed on save | Excel Discussion (Misc queries) | |||
| Exclusive use Problem | Excel Discussion (Misc queries) | |||
| How do you make an Excel workbook exclusive? | Excel Discussion (Misc queries) | |||
![Donna[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
