COUNTIFS

Hi @Marilen.Navarro103391,

Hopefully I understand what you're trying to do. Try this:

Expand your metric sheet to look like this so you have a section for each person. If you end up with more than two or three people you may want to rethink how your sheets are structured.

. Then for each raw materials sheet add a "helper" column called Month and put this formula in it: =MONTH([Date Rcvd]@row) and make sure it's copied to all rows. Here's what this may look like in an example where I created a Pattern sheet:

. Then add a row to your metrics sheet with the month numbers (see row 1 in my example above). You can hide this row later using a filter if you need to.

. Then in the cell marked below with a red box, enter the following formula: =SUMIFS({Pattern Sheet - Purchase Amount Column}, {Pattern Sheet - Month Column}, January$1, {Pattern Sheet - Name of Person Column}, $[Primary Column]$3)

Note: $[Primary Column]$3 refers to the cell with the name Joseph in it.

. Copy the formula across all the months.

. Then do the same for the other raw material sheets

Notice the external references to the Pattern raw materials sheet. If you are not familiar with how to do external sheet references, let me know.

. Finally, do the same for the ($) metrics section for each person using this formula: =SUMIFS({Pattern Sheet - Booked Column}, {Pattern Sheet - Month Column}, January$1, {Pattern Sheet - Name of Person Column}, $[Primary Column]$3) and copy it across as well.

I hope all this makes sense.

Cheers,

Ramzi