| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sumif to add data in multiple sheets
I am trying to use sumif to form a summary page as a Year to date from a
summary on each of twelve month worksheets which have a sumary using the sumif on each page. This is my formula =SUMIF(Jul:Jun!B54:F58,A4,Jul:Jun!D54:D58) it just comes up with #VALUE. What is wrong with the formula. I am using the same formula on each of the individual months sheets and it works. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) | |||
Threaded Mode
