Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I want to add a condition to a formula so that the formula only returns a
result if the condition is met. Here is the formula: =SUMIF(PO!$AI$24:$AI$1499,PO!$AI195,PO!$AN$24:$AN$ 1499) If an additional cell PO!$AR195 contains the value "Yes" the formula will return a result. If there is no value in PO!$AR195 then no result will be returned. Anyone know how to incorporate the above condition into the formula? Many thanks if you can help. Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |