Ladkisson

asked on

# Sumif formula

Hi,

this is my current formula:

=SUMIFS($D$3:$D$1650,$B$3:$B$1650,$B1657,$A$3:$A$1650,"test")

I need to add column C to the above formula. Column C has dates information in the following format: 2012 WEEK 49, starting from 2012 WEEK 1. I need to sum the values in the following range: 2012 week 44 trhough 2012 week 50.

thank you!

this is my current formula:

=SUMIFS($D$3:$D$1650,$B$3:

I need to add column C to the above formula. Column C has dates information in the following format: 2012 WEEK 49, starting from 2012 WEEK 1. I need to sum the values in the following range: 2012 week 44 trhough 2012 week 50.

thank you!

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.