Convert this equation to search based on two dates from O1 to K1

**saftawy1** · 10-26-2021, 05:18 PM

Please help
I want to convert this equation to search based on two dates from O1 to K1

IFERROR(SUMPRODUCT(A3:K3*(B3:L3<=$O$1)*ISODD(COLUMN(A3:K3))),"")

thank you for your helping

**saftawy1** · 10-27-2021, 08:27 AM

model attached

**saftawy1** · 10-28-2021, 09:38 AM

I have come up with a rudimentary solution
IFERROR(SUMPRODUCT(A3:K3*(B3:L3<=$O$1)*ISODD(COLUMN(A3:K3)))-SUMPRODUCT(A3:K3*(B3:L3<$K$1)*ISODD(COLUMN(A3:K3))),"")

thank you everybody

Convert this equation to search based on two dates from O1 to K1

LinkBack

Thread Tools

Rate This Thread

Display

Convert this equation to search based on two dates from O1 to K1

Re: Convert this equation to search based on two dates from O1 to K1

Re: Convert this equation to search based on two dates from O1 to K1

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Search for min and max dates based on conditions

Cannot convert VLOOKUP equation into a range equation

convert list of dates to Date ranges based on conditions

Convert formulas to values based on dates

Search between dates and add SUM of value based on entered week no.

Convert dates into month (numerical) based on condition

Need an equation to index match based on a criteria, Within another equation...

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions