Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add several functions in one formula
Hi,
If I already have a "SUMIF" formula (see below) which returns a certain value and I would like Excel to add to that formula an additional function that adds certain data from an additional column in a tab - where and how do I do that in the formula? The thing I would like to do is: Add data from a column but only all the rows with a special value in that column, for example with the string "Open". =SUMIF('Jira Reference'!$J:$J;"<="&C5;'Jira Reference'!$L:$L)/3600 I also to that formula would like to add the value of those same rows that says "Open" but from another additional column and also multiplicate that with 50%. -- Brile |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
If/Or Formula Functions | Excel Discussion (Misc queries) | |||
Using the AND and OR functions in the same formula | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) |