Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with sumproduct
using this formula
=SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),M ONTH(TODAY())+0,1),"yyyymm"))) when column E is mark with "X", i want the values in column H to be not added. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with sumproduct
see your other post
-- Biff Microsoft Excel MVP "tleehh" wrote in message ... using this formula =SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),M ONTH(TODAY())+0,1),"yyyymm"))) when column E is mark with "X", i want the values in column H to be not added. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |