| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Modifying sumif formulas.
=SUMIF(B:B,B92,AE:AE)+SUMIF(B:B,B92,AI:AI)+sumif(b :b,b92,AK:AK)
This was the start to one formula on a spread sheet, my simple question is can this be condensed. is there such thing as =sumif(b:b,b92,ae:ae&ai:ai&ak:ak) - The whole purpose of condensing the formula is to be allow others to follow the path especially auditors. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Using SumIF formulas with multiple lookup values | Excel Worksheet Functions | |||
| sumif and array formulas | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| formulas SUMIF & DSUM | Excel Discussion (Misc queries) | |||
Threaded Mode
