SUMPRODUCT formula:pretty simple formulae

I have a pretty simple formulae that matches a code in "Jan Timesheets" tab, column A against the code in the "Summary" tab, column A and totals the values for this match in timesheets column V, this reads as follows:

=SUMIF('Jan Timesheets'!A:A,Summary!A14,'Jan Timesheets'!V:V)

What i now want to do is bring this data across but not only matching code in Timesheets AA, but match with Timesheets AA and B:B equals 0100?

Any help much appreciated, i'm still leaning formulaes as you can probably tell ...

hi, would you like to post an example?

sure, thanks.

In summary tab i need to match by the code (i.e GB02) for all 0100 values in column C of the Jan Timesheets tab

G'day

Try this. Place formula in C3 on the "Summary" Sheet

Please Login or Register  to view this content.

Plus I'll need to place some data of 0100 for it to count the code.

Crossposted - solutions already offered at

http://www.excelforum.com/showthread.php?t=645054