Hi all,
I'm hoping for your great help once again. Ive added attachement with a txt box of what i am trying to achieve.
but it is looking through 4 columns for 1 key word in each column and sum of matching all 4 words.
Hi all,
I'm hoping for your great help once again. Ive added attachement with a txt box of what i am trying to achieve.
but it is looking through 4 columns for 1 key word in each column and sum of matching all 4 words.
Use 4 formulae like this one, one in each of the shaded ranges:
=SUMPRODUCT(($A$2:$A$10=$H$4)*($B$2:$B$10=$H5)*($C$2:$C$10=$J$3)*($D$2:$D$10=J$4))
Two because of two result rangesx 2 becasue of those merged cells!!
Each 2x2 block is copy pasted, there are minor variants thereafter.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi bazfalty,
This looks like a Pivot Table answer to me with two groups for rows and columns. See if the attached does what you want/need.
Pivot Table with two row and column groups.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
thanks for this as well
No problem!! You can't add rep to the same person successively. You have to spread the love around!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks