Match Index lookup

Hi, i need a match index

I need to match Rev A IN tab graphs with monday to Sunday, looked up against columns F & I in tab raw data

Basically im trying to match the sum of rev A for each day off the week

I manually added the first for reference
Home-Store-Project.xlsx
Seamus2626Asked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

pls try in A8

=SUMIF(Raw_Data!$I:$I,Graphs!A$7,Raw_Data!$F:$F)

Open in new window

in A13
=SUMIF(Raw_Data!$I:$I,Graphs!A$7,Raw_Data!$G:$G)

Open in new window

in A18
=SUMIF(Raw_Data!$I:$I,Graphs!A$7,Raw_Data!$H:$H)

Open in new window

and fill to right in each case

Regards
0
 
Seamus2626Author Commented:
Thanks Rgonzo!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.