# Thread: Help with nesting Sumproduct and Countifs

1. ## Help with nesting Sumproduct and Countifs

Hi All - I have two formulas (below) that work fine independently, however I need to embed these to return 1 result based on the two criteria. I've tried numerous combinations, but can't get them to work. So time to call on some expert assistance.

=SUMPRODUCT((WEEKDAY('Rec inj and cat 3 above import'!\$I\$8:\$I\$1000)=1)*1)

=COUNTIFS('Rec inj and cat 3 above import'!K8:K2000,A98)

Any assistance would be much appreciated.

Regards

2. In what cell is the result of the sumproduct?

Not quite sure what you're trying to count.

3. Hi Thanks for the reply

I'm trying to count the number of dates that are a Sunday (1) (in this case) in !\$I\$8:\$I\$1000 that meet the criteria at A98 in the countifs.

Hope that hepls

Regards

=SUMPRODUCT((A98='Rec inj and cat 3 above import'!K8:K2000)*(WEEKDAY('Rec inj and cat 3 above import'!\$I\$8:\$I\$2000)=1))

[need the same number of cells in the range]