Match Index lookup

Seamus2626
Seamus2626 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
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

Author

Commented:
Thanks Rgonzo!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial