Formula to sum non-contiguous cells

Hi All,
I am looking for help with a formula. I am wanting to sum multiple non-contiguous cells from one sheet and place the result in a cell on another.

Please find the sheet attached for reference. I'd like to sum the following cells (D2+D11+D20+D29) from 'All Regions Source Data' and for the result to appear in V32 on the 'Excel Reporting Templates' sheet.

I am using the following formula to get a single cell value

='All Regions Source Data'!D31

and would like to use a variant on this simple forumla if at all possible.

Thanks in advance for any help!

You could use SUMIFS for this, along the lines of:

=SUMIFS('All Regions Source Data'!$D:$D,'All Regions Source Data'!$A:$A,U32)

This will give you the total for all months, but I think you just want it for one month given the table headings. I am not sure where you are specifying the date (or month) of interest though.

Hope this helps.

Pete

Hi there,

The solution to (my understanding of!) your question as written is:

Please Login or Register  to view this content.

entered in Cell V32, but this seems a bit too easy to be what you're really looking for


Regards,

Greg M

@Pete_UK

That's right -- I am trying to get a results on a monthly basis. What I am looking for is the count of a specific 'Type' (column A) for a particular 'Region' (column B) during a specific 'Month' (column C).

So with the sum of (D2+D11+D20+D29) I am looking for the number of 3rd Party Host Connection Problems across all 4 of the regions during January.

@Greg M

That is exactly what I am looking for -- I tried and it works! So simple -- cannot believe I did not think of this

Thanks for your help!

Hi again,

Many thanks for your very prompt feedback.

Delighted to have been able to help - sometimes the simple ways are best!

Regards,

Greg M