SUMIF or SUMIFS

Do I need a SUMIF or SUMIFS formula? Not sure how to properly create this formula, or if this is even the right one to use here.

I have a summary table on one tab (Summary) with expense categories that I need to summarize from the Product Sched tab. The sum needs to be by the appropriate month, capturing all of the expenses for the month that are categorized as "Pre-Clinical Studies" for example, regardless of which product they are associated with.

Please see attached example.
Thanks!!

Basically, SUMIF is used only for a single condition, whereas SUMIFS can be used for multiple conditions. It seems to me that you have two conditions, i.e. month and category, but I'll take a look shortly after I've had a coffee break.

Pete

Actually, there is only one condition, but you can still use SUMIFS in this situation. Put this formula in cell D3:

=SUMIFS('Product Sched'!D:D,'Product Sched'!$B:$B,$B3)

Then you can copy across and down as required.

Hope this helps.

Pete

Pete_UK - this is exactly what I needed. Thanks so much for your help!!

Sorry about that, I added to the Thread Title to be more specific. Thanks Admin!! It's been years since I've come onto this forum and should have re-read the rules!!

Glad to help.

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

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete