Sumproduct, countif and format?

J

jseppeli

Joined
Sep 3, 2013
Messages
1
Reaction score
0
Hello

I have an excel file that worked before in XP but now I have changed to Win7
Same version of Office (2007) in use

I have used a formula like this
=SUMPRODUCT(--(TEXT(PR_JSE002_2013!C1:C99999;"mm.yyyy")="01.2013");--(TEXT(PR_JSE002_2013!P1:P99999;"mm.yyyy")="FI08"))

Is there any other way to get Excel to count column C where the dates are and column P where the "plant" code is?

What I mean is that I want it to count if month is January and "plant" is FI08

C column looks like this
Purchase Requisition 17794278

11.1.2013
11.1.2013
11.1.2013

Purchase Requisition 17797682

11.1.2013

Purchase Requisition 17797683

11.1.2013

Purchase Requisition 17797684

11.1.2013

And P like this


FI08
FI08
FI08



FI06



FI06



FI06

Dates and "plant" codes are on same rows
 
Last edited:
Back
Top