Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm hoping someone can help with the following...
I tried checking the SUMIF and SUMPRODUCT archives with no success. Maybe I am not using the correct function. Here is my current formula =SUMIF(M2680.001,(AND(sum(BS268+BT268-BU2680,BS268+BT268- BU268),*AZ268*(1-BF268)))) What I want is if the first 2 conditions are met M268 .001 and BS268+BT268-BU268 0 then I want the sum of BS268+BT268+BU268 if not then I want AZ268*(1-BF268) Any help would be greatly appreciated! cheetah |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif and sumproduct together | Excel Discussion (Misc queries) | |||
sumif vs sumproduct | Excel Worksheet Functions | |||
Sumif or Sumproduct | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions | |||
SUMIF or SUMPRODUCT or something else? | Excel Worksheet Functions |