sumprodcut issue

[bluepenink]

hello there

having some issue with a simply sumproduct

=SUMPRODUCT(--('Invoice Count (Combined)'!$A$2:$A$12000=Sheet5!$A14),--('Invoice Count (Combined)'!$D$2:$D$12000=Sheet5!$B$4),('Invoice Count (Combined)'!$F$2:$AW$2=Sheet5!$B$15))

'Invoice Count (Combined)'!$A$2:$A$12000 ...range where country i.e. CA, US etc

A14 = Country i.e. CA, US

'Invoice Count (Combined)'!$F$2:$AW$2=Sheet5!....row where it contains the data i want to obtain, with AW being the header i.e. P7 YTD

$B$15 = P7 YTD (header title)

B4 = Purge (type of invoice - i want by, other than country)

'Invoice Count (Combined)'!$D$2:$D$12000 ...type of invoice i.e. purge, offsite etc.


so im trying to get by country i.e CA, by criteria i.e. purge, the value in sheet Invoice Count (Combined) in cell AW.

can someone pls help me with my logic

thx u so much <!-- / message -->

 

[barry houdini]

Does this work for you?

=SUMPRODUCT(('Invoice Count (Combined)'!$A$2:$A$12000=Sheet5!$A14)*('Invoice Count (Combined)'!$D$2:$D$12000=Sheet5!$B$4)*('Invoice Count (Combined)'!$F$2:$AW$2=Sheet5!$B$15),'Invoice Count (Combined)'!$F$2:$AW$12000)

....or possibly more efficient if there will only be one match for B15 in header row

=SUMPRODUCT(--('Invoice Count (Combined)'!$A$2:$A$12000=Sheet5!$A14),--('Invoice Count (Combined)'!$D$2:$D$12000=Sheet5!$B$4),INDEX('Invoice Count (Combined)'!$F$2:$AW$12000,0,MATCH(Sheet5!$B$15,'Invoice Count (Combined)'!$F$2:$AW$2,0)))