Forum Discussion
Sumifs
Hi I am trying to use SUMIFS to register weekly totals from one worksheet to another... For example, I have one worksheet that I manually enter data on week by week and i would like to automati...
Abiola1 Thanks for getting in contact here are some photos that may help describe what i mean...
Hello, based on the pictures attached, I noticed that, in your Weekly sheet, you merged cell I20 and J20 together which should not be so.
In addition, SUMIFS first argument is sum_range which must be at least 2 cells that contains numeric values. In your case, your sum_range is only a single cell which you also merged as pointed earlier.
I think you need to re-design your spreadsheet to use the SUMIFS better. Caption below is how single criteria SUMIFS should work