| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditinal format of cells within a worksheet + woorkbook
I have several worksheets - i need to reference from one sheet 3 different
values IE text, text, then add the values. EG range A1:A1000 looks for a value =HPI835 Range B2:B2000 looks for a value on sheet to which must be =A2 then it must add all the values found together an put it onto sheet 3 in BD34 if this does not make sence then have a look at this formula i used which works well for a few cells but not for a range of cell it as an array formula {=SUM(IF((Report!$B$2:$B$20000="ESM005")*(Report!$ F$2:$F$20000='Kit Planes'!$A4),Report!$C$2:$C$20000))} please can somebody help me to solve my problem.. many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I Perminatly Format Comment Boxes in my Woorkbook? | Excel Worksheet Functions | |||
| TAB NAME IN A WOORKBOOK REFER TO A CELL ON WORKSHEET | Excel Discussion (Misc queries) | |||
| Conditinal Format | Excel Worksheet Functions | |||
| conditinal format that gives particular shape and color in cell | Excel Discussion (Misc queries) | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
