# sum based on dates with specific cells

1. ## sum based on dates with specific cells

hello

In F40 – I need a formula to work with the exiting formula to look at a date in f38 and then sum highlighted cells… sums between the dates in f38 & h38

I’ve entered it manually at the moment to show expected results

thanks

2. ## Re: sum based on dates with specific cells

=IFERROR(INDEX('mfg weekly'!\$A\$1:\$N\$1240,MATCH(A40,'mfg weekly'!\$A\$1:\$A\$1240,),7)-SUM(\$J\$6:\$S\$28*(\$J\$3:\$S\$3>=F\$38)*(\$J\$3:\$S\$3<H\$38)*(\$A\$6:\$A\$28=\$A40)),"0")

3. ## Re: sum based on dates with specific cells

Translated:

=IFERROR(INDEX('mfg weekly'!\$A\$1:\$N\$1240,MATCH(\$A40,'mfg weekly'!\$A\$1:\$A\$1240,),7)-SUM(\$J\$6:\$S\$28*(\$J\$3:\$S\$3>=F\$38)*(\$J\$3:\$S\$3<H\$38)*(\$A\$6:\$A\$28=\$A40)),"0")

Courtesy of https://en.excel-translator.de/translator/

4. ## Re: sum based on dates with specific cells

Not sure I understand everything, but try something like this.
F37 formula
Cell F40 formula and copy down
Greetings.

5. ## Re: sum based on dates with specific cells

Translated:
=IFERROR(INDEX('mfg weekly'!\$A\$1:\$N\$1240,MATCH(\$A40,'mfg weekly'!\$A\$1:\$A\$1240,),7)-SUM(\$J\$6:\$S\$28*(\$J\$3:\$S\$3>=F\$38)*(\$J\$3:\$S\$3<H\$38)*(\$A\$6:\$A\$28=\$A40)),"0")

6. ## Re: sum based on dates with specific cells

Please post your formulae in English in future, Tim, then there won’t be any need for translations. This is an English-speaking forum, after all. Of course, you could have just said thanks!

7. ## Re: sum based on dates with specific cells

Spasibo!________

8. ## Re: sum based on dates with specific cells

this also worked very well

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1