| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What is the best method for summing values where you want 2 value.
An example of this is: If F2=A1:A5, and G1=B1:B5, then sum values. I have
tried an array formula, but it does not return any results. Below is the formula I was trying. I have used Booleon format also, but it is hit and miss. =SUM(IF(AND($A3=Raw!$A$2:$A$297,Summary!$C$1=Raw!$ C$2:$C$297),Raw!$E$2:$E$297,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Count number of Unique values | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
