Help with multiple arguments

Hi

I have attached a sample workbook which I need assistance with.

I need to record the sum of the figures in column C in J2 - this figure (J2) should show the sum of the figure if the date in the adjacent column (B) is today's date. However, I do not want to include the figure in C column if the QUERIED (D2) column is populated with "Y" and I also do not want to include the figure in the C column if the adjacent F column cell contains a figure.

So J2 should show the sum of the figures in column C unless the adjacent columns D or F are populated.

I cannot figure it out.

Put this in J2:

=SUMIFS(C:C,B:B,TODAY(),D:D,"<>y",F:F,"")

Note that the syntax for SUMIFS differs from that of SUMIF.

Hope this helps.

Pete

Works perfectly.

Thanks a lot my friend.

Glad to be able to help - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete