Sumproduct - range as criteria

T

Thommo

Can I have a range of cells as my sumproduct criteria?

column A has PayTypes
Normal
Otime
Annual
column B has area
area1
area2
area3
column C has Pay
1000
2000
etc
Column D has Dates

I have an area Q2:Q5 with Pay types listed and want to sum by any I put in
that area for various scenarios

Any help appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top