• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create a lookup from a range based on a word search

S

seansr

Member
I want to do a look up in a within a range based on the word.
The entry may change so the word Wet many be in any row in a given range, but I want to report the Weekly total in column J
So in this example *Wet = £2814.50
 

Attachments

  • wsob.xlsx
    9.4 KB · Views: 12
Do you mean the answer should be $9356.78?
I'm unsure because 2814.50 is in Column H?

You can use: =SUMIFS(J4:J6,B4:B6,"*Wet*")
 
Sorry Yes I want the Total in Column J based on the Group name in column B
The example is a small example if the sheet that will have loads of sites but the group names are not static
So I have another spread sheet that I want to say
For Site 1 Give me the Total Wet, and the Total Dry and the Total Misc, and could ne loads more
But depending on the export they could be in different rows. the rows only show if the row is used, but there are many group names that can be used per site but I know they should always be within a given range
 
You must log in or register to reply here.
Back
Top