Not all cells found with SUMPRODUCT

[JOGIER]

I have no clue whats going on with this data. Most of the values transfer from the 'Log' to the "Table' with no problem but for some reason, that escapes me at this time, all do not. Any help would be appreciated.

A sample of the problem is enclosed.

Jim O

[daddylonglegs]

All the headers need to match the text in Log column A, Jim. For example Cable/Internet in Q3 has no spaces while Cable / Internet in column A has spaces either side of the /

Similarly "Nationwide Auto" and "Auto Ins" won't match......cos they're different!

[martindwilson]

=SUMPRODUCT((Log!$A$5:$A$30=H$3)*(Log!$D$5:$D$30=$B18)*(Log!$B$5:$B$30=H$2)*Log!$F$5:$F$30)
list in col a log sheet does not match list across columns on data d3:s3
eg equity line is not in column A it says chase equity instead which will not match data!h3
get rid of spaces and make sure names tally
blue cells add values which is correct beacause thats what you have told it to do.

[JOGIER]

Thank you both for your responses. That was it.

Still learning the basics with this Excel stuff.


Jim O